Symptom
Xcelsius displays inconsistent results using Qaaws when data has null value
Environment
- Business Objects Enterprise (BOE) 3.1
- Query as a Web Service (QaaWS) 3.1
- Xcelsius 2008
Reproducing the Issue
- Create a Qaaws query, make sure it has some null values.
- Copy the query to clipboard and import it inside Xcelsius.
- Click on 'Data and connections'.
- In the 'Output Value' Window link each column element inside Xcelsius to different rows in Excel.
- Preview the dashboard which generates inconsistent results
Cause
- To maintain the <row><column> format in the table regardless of NULL data, bind the entire row folder of the table’s body in the Data Manager
- By linking each column element individually, SWF file will have no row reference to place a NULL cell and will therefore be skipped
- In turn generating inconsistent results inside Xcelsius.
Resolution
1) Open Xcelsius
2) Click on the Qaaws connection
3) Select rows and bind the entire range of output values to Excel.
Keywords
KBA , BI-RA-XL , Obsolete: BusinessObjects Dashboards and Presentation Design , Problem
Product
SAP BusinessObjects Xcelsius Enterprise 2008