SAP Knowledge Base Article - Public

1768823 - Qaaws giving inconsistent results in Xcelsius

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

  1. Create a Qaaws query, make sure it has some null values.
  2. Copy the query to clipboard and import it inside Xcelsius.
  3. Click on 'Data and connections'.
  4. In the 'Output Value' Window link each column element inside Xcelsius to different rows in Excel.
  5. 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