Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
OBIEE Dshbrd Prompts - How can you required e.g. 3 values to be selected by User

We have a requirement to force a user to select at least 3 values from a dashboard prompt filter.
I.e. The prompt is for a Customer Name, the user should at least select 3 names, but could select more. But not less.
Any ideas how to code that?? We use 11.9
Answers
-
Not a simple checkbox allow you to define that kind of condition in the prompt, but you can easily setup a display condition on the section(s) of your page showing your analysis only if 3 or more values are selected.
1) You create you prompt without any special setting
2) You create an analysis containing only the column of your prompt and set a filter as "is prompted"
3) Define a display condition on the section(s) of your page containing the analysis where the 3 minimum values are required and set the "True if Row Count" is >= 3
optional:
4) add a new section with the same analysis as condition but setting the "True if Row Count" < 3 and display a text message reminding your user at least 3 values are required
0 -
Thanks! I will try this out
0