SAP Knowledge Base Article - Public

2218984 - Dashboard Display options of Query Prompt Selector is grayed out

Symptom

  • Dashboard Display options of Query Prompt Selector is grayed out
  • Universe (unx) datasource and prompt is set in query

Environment

  • Business Intelligence Platform 4.1 Support Package 06 (BI4.1 SP6)
  • Dashboard Designer 4.1 Support Package 06 (Dashboard 4.1 SP6)

Reproducing the Issue

  1. Create a new blank Dashboard in Dashboard Designer.
  2. Open Query Browser, add a new query against universe datasource.
  3. In Filters panel, set a prompt with operator "Equal to".
  4. Run the query and then close the Query Browser.
  5. Add a Query Prompt Selector component into canvas.
  6. In General tab of the Query Prompt Selector, set it to be associated to the prompt created in step 3.
  7. In Appearance of the Query Prompt Selector, Choose Layout, observe the Display Options is grayed out.

Cause

Display Options cannot be used while the prompt operator is set to "Equal to".

Resolution

Change the prompt operator to "In List" operator. 

Keywords

grey, Hierarchy Levels, Horizontal, Vertical, Expanded, Collapsed, Expand Level, Expand All Levels, Collapse All Levels , KBA , BI-RA-XL , Dashboards and Presentation Design , How To

Product

SAP BusinessObjects Dashboards 4.0