1383348 - NULL value idisplays as "Undefined" label in Xcelsius list builder component

SAP Knowledge Base Article - Public

1383348 - NULL value idisplays as "Undefined" label in Xcelsius list builder component

Symptom

"Undefined" labels display in Xcelsius list builder component

Reproducing the Issue

  1. Design table in DB system, and allow NULL columns.
  2. Add some records into this table with some NULL values for some columns
  3. Create a Universe based on this table
  4. Use QaaWS to create a web service based on this Universe
  5. Create a dashboard based on this web service
  6. In Xcelsius, add List Builder and set these NULL values as the labels
  7. Preview this dashboard, "undefined" labels displayed

Cause

NULL value was treated as "Undefiend" labels, thus it reminds the Xcelsius designer to enhance the design.

Resolution

Please use ISBLANK formula to change NULL vaules to ""(blank) in Excel

Keywords

NULL, Undefined, Xcelsius, List Builder. , KBA , BI-RA-XL , Dashboards and Presentation Design , How To

Product

SAP BusinessObjects Xcelsius Enterprise 2008