Symptom
"Undefined" labels display in Xcelsius list builder component
Reproducing the Issue
- Design table in DB system, and allow NULL columns.
- Add some records into this table with some NULL values for some columns
- Create a Universe based on this table
- Use QaaWS to create a web service based on this Universe
- Create a dashboard based on this web service
- In Xcelsius, add List Builder and set these NULL values as the labels
- 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 , Obsolete: BusinessObjects Dashboards and Presentation Design , How To
Product
SAP BusinessObjects Xcelsius Enterprise 2008