SAP Knowledge Base Article - Public

1715453 - Filter does not show full List Of Values when building query within query builder.

Symptom

Only first value is shown when a filter is set to List of Values when Building query within Query Designer in Dashboard

Environment

  • Dashboard 4.0 Feature Pack 3

Reproducing the Issue

  1. Create a Bex Query with filters and restrict them using Range Variables. Make sure to make them Mandatory.
  2. Create a connection to Bex query within IDT
  3. Within Dashboard add a query by clicking on Add Query Button within Query Browser.
  4. Authenticate by entering User ID/Password
  5. Select "BEx" as a data Source
  6. Select the connection made within IDT (done in Step 2)
  7. Once the query structure is displayed, create a filter by dragging any characteristics within "Filter Area".
  8. Under the "Type of constant" drop down, select "List Of Values".
  9. Wait for the list of values to be displayed.
  10. You'll see only 1 values (very first value) is displayed.

Cause

This is a limitation in Dashboard 4.0 Feature pack 3. BEx Variable with range values input is not supported

Resolution

Recommendation is to exclude the range value variable from you the BEx query. Once that is done, full List of Values will be shown.

Keywords

KBA , BI-RA-XL , Dashboards and Presentation Design , Problem

Product

SAP BusinessObjects Dashboards 4.0