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
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.
Avinash Gupta replied
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.