OBIEE Dshbrd Prompts - How can you required e.g. 3 values to be selected by User

Question

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

1322506 · Answer

Thanks!  I will try this out

Gianni Ceresa · Answer

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