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
- Create a BEx query with optional prompt.
- Consume the BEx query in Dashboard.
- Hardcode the LOVs in embedded spreadsheet.
- One of the LOVs will be blank in order to retrieve the entire data without filtering.
- Preview the dashboard and select the empty value.
- 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