SAP Knowledge Base Article - Public

2103395 - BW variable greyed out in the query browser in Dashboard

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:

  1. Create a variable at the BW or HANA level.
  2. 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:

  1. Create a prompt in the IDT.
  2. 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 , Dashboards and Presentation Design , Problem

Product

SAP BusinessObjects Dashboards 4.0 ; SAP BusinessObjects Dashboards 4.1