1521098 - SAP BW Variables not overridden by Xcelsius, when passed via a Combo Box with Status list insertion method

SAP Knowledge Base Article - Public

1521098 - SAP BW Variables not overridden by Xcelsius, when passed via a Combo Box with Status list insertion method

Symptom

  • BW variables are not overridden by Xcelsius when passed via a Combo Box with Status list insertion type to the SAP NetWeaver BW connection.
  • If the variable's default value in BEx is 1, it is not overridden to 0 after different item is selected in the Combo Box

Environment

  • Dashboard Builder (Xcelsius) 2008 Service Pack 3 Fix Pack 2

Reproducing the Issue

  1. Create a SAP BW query with few formula variables (one with default value 0 and one with 1)
  2. Create an Xcelsius dashboard based on a SAP NetWeaver BW Connection
  3. Map the input variables into cells
  4. Map the output variables to different cells
  5. Add a Combo Box to the canvas and configure it to use the “Status list” as insertion type, and as destination select the same cells used by the connection
  6. Add a Spreadsheet Table pointing to the cells with the output variables
  7. Add a Refresh button and configure it to refresh the SAP BW connection
  8. Publish the dashboard to SAP BW
  9. Launch the dashboard, select different values and refresh the connection

The variables with default values set to 1 are not overridden by Xcelsius, therefore if the variable s used in a filter, the query does not return correct data

Cause

When evaluating for NULL, 0 was ignored and not passed in the HTTP request.

The issue has been identified and logged under Problem Report ID ADAPT01488426.

Resolution

This issue is scheduled to be addressed in Fix Pack 3.4

Keywords

BW variables not overriden, Status List, 01488426, 1488426 , KBA , BI-RA-XL , Dashboards and Presentation Design , Bug Filed

Product

SAP BusinessObjects Xcelsius Enterprise 2008