Symptom
Only one value is accepted when a prompt is presented for a Range Variable based off a BEx Query within Query Builder in Dashboards.
Environment
- Dashboards Design 4.x
- Dashboards Design 4.x
Reproducing the Issue
- Create a BEx Query with filters and restrict them using Range Variables.
- Create a connection to that BEx query in IDT
- Within Dashboard add a query by clicking on Add Query Button within Query Browser.
- Authenticate by entering User ID/Password
- Select "BEx" as a data Source
- Select the connection made within IDT (done in Step 2)
- Once the query structure is displayed, select characteristics to display.
- Click Next to get prompted for the
- Click to enter value, you'll see single value could be entered rather than a range.
Cause
This is a limitation in Dashboard 4.0. Variable with range values input is not supported.
Resolution
Recommendation is to exclude the range value variable from the BEx query. You can achieve the same goal by adding a filter with operator "Between" in the query panel.
Keywords
KBA , BI-RA-XL , Obsolete: BusinessObjects Dashboards and Presentation Design , Problem
Product
SAP BusinessObjects Dashboards 4.0