SAP Knowledge Base Article - Public

1984740 - Passing empty value / blank through combo box does not retrieve data in Dashboard

Symptom

When an empty value is passed by combo box to BEx query so as to retrieve entire data without filtering; no data is retrieved.

Environment

  • SAP Dashboards 4.0

Reproducing the Issue

  1. Create a BEx query with optional prompt.
  2. Consume the BEx query in Dashboard.
  3. Hardcode the LOVs in embedded spreadsheet.
  4. One of the LOVs will be blank in order to retrieve the entire data without filtering.
  5. Preview the dashboard and select the empty value.
  6. Observe that no data is retrieved.

Cause

  • The empty value passed from the combo box is not recognized by the BEx query.

Resolution

  • Use the 'query prompt selector' component

Keywords

Xcelsius, Dashboard, Combo box, failed to retrieve data, empty value, BW, variable, bex variable , KBA , BI-RA-XL , Obsolete: BusinessObjects Dashboards and Presentation Design , Problem

Product

SAP BusinessObjects Dashboards all versions