Hi,
I need to create a user prompt with a LOV based on a text file. The LOV values are static and are 1,2,3. These values do not exist in the database and are to be used for a calculation in the report. How can I create a user prompt without assigning the @prompt to a database table column? Shouldn’t all prompts be like table.column = @prompt()?
Do I have to create a prompt with any column and then use a custom sql in the webi to use the user prompt value in the claculation using say userresposne()?
Could you please explain how to use static values? My aim is to enable user to enter a prompt value not in the database and use the value in a calculation. Say the user enters a percentage value and I use that value in a calculation as [MeasureObject] * [user entered percentage]. Percentage value entered by user can be any number between 1 and 100. How to create this prompt?
Your condition does need to apply to an object. Furthermore, the object needs to be of the same type as the data that will be entered into the prompt (e.g., you can’t ask for a percentage using a string object).
The simplest solution that I’ve used in this scenario is to use an object that stores monetary values, and use a prompt like:
[Sales] Not Equal To “Enter Percentage Value:”
Since you are unlikely to ever have a sale with a value of just pennies, the filter doesn’t actually remove any records. Then you can reference the prompt value in the report.
(BOB member since 2012-11-06)
(BOB member since 2011-07-27)