Symptom
- Variable defined at BW/HANA is greyed out in the query browser in Dashboards when there is another filter applied while creating the query in Dashboards.
- Prompts defined at the universe level are greyed out when there is another filter applied while creating the query in Dashboards.
Environment
- SAP BusinessObjects Dashboards 4.0
- SAP BusinessObjects Dashboards 4.1
Reproducing the Issue
Scenario 1:
- Create a variable at the BW or HANA level.
- In Dashboards, create a query with a filter i.e. drag a object in the filter section.
It is observed that the BW/HANA variable is grayed out.If the filter in the query browser is not applied then the BW/variable is not grayed out.
Scenario 2:
- Create a prompt in the IDT.
- In Dashboards, create a query with a filter i.e. drag a object in the filter section.
It is observed that the prompt defined in IDT is grayed out.If the filter in the query browser is not applied then the BW/variable is not grayed out.
Cause
The filtering of data cannot be done at both the BW/HANA level and the Dashboards level.
Resolution
Data should be filtered either at the BW/HANA level or at the Dashboards level but not on both the levels.
Keywords
Dashboards, BW variable, grayed out,query browser, unavailable , KBA , BI-RA-XL , Obsolete: BusinessObjects Dashboards and Presentation Design , Problem