Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Received Response
1
Views
2
Comments
1322506
1322506 Rank 3 - Community Apprentice

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

    Capture.PNG

    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

  • 1322506
    1322506 Rank 3 - Community Apprentice

    Thanks!  I will try this out