Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Report Query

HI All

We have 3 prompts

1 prompt user enter the values, 2 prompt with lov, 3 prompt with lov.

in the query we want to pass

select

datavalue,timestamp from numericlog where logname = concat(concat(prompt1,prompt2),prompt3)

so that the user can get the result set.

We are getting the above values from symentic layer. 

Can we do this in webi or we should do this on Symenticlayer itself or how should we do this.

Tags:
Former Member
Former Member replied

Hi Kalika,

Please follow the steps :

All the three prompts which the user enters, create them at the universe level using a Filter condition with @Prompt .

So your three prompts would be like :

Condition 1 = (Column = @Prompt (,,,,,,,)

Condition 2 = (Column = @Prompt (,,,,,,,)

Condition 3 = (Column = @Prompt (,,,,,,,)


When you will add these three conditions in the report, your three prompts will appear as it does now.


Now to Concatenate these three user values in one Prompt at the run time :


Add another condition for Logname in your case:


Condition 4 = (Column =  '@Where (Condition 1)' || '@Where (Condition 2)' || '@Where (Condition 3)'


Or else you can directly write the @Prompt Syntax  instead of @Where and contact it using pipes or Concatenate function.


Add this condition 4 in the report, This will not prompt you anything extra, the values passed for other prompts will be used in this prompt at the run time to Concatenate the string .


The above example is with Oracle, tweak the functions and syntaxes as per the database.


Please let me know if this helps.


Thanks,

Avinash

1 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question