1467212 - Results are inconsistent between Preview mode and Canvas mode when blank cell is included in the formula in Xcelsius 2008 SP1

SAP Knowledge Base Article - Public

1467212 - Results are inconsistent between Preview mode and Canvas mode when blank cell is included in the formula in Xcelsius 2008 SP1

Symptom

Results are inconsistent between Preview mode and Canvas mode when blank cell is included in the formula

Environment

  • Xcelsius 2008 SP1

Reproducing the Issue

  1. Create a Xcelsius file using the following values in spreadsheet.
    A1=””
    B1=A1<>""
    C1=A1<>0
  2. Insert a Spreadsheet Table component to Canvas area, and select a range for Display Data using the following range.
    Sheet1!$A$1:$C$1
    You can observe that cell B1 and C1 display “false” in Canvas mode.
  3. Click Preview.
    You can observe that cell B1 and C1 display “true” in Preview mode.

Note: The issue only occurs when the value of cell in formula is blank.

Cause

The issue doesn’t occur in Xcelsius 2008 SP2, however there is no ADAPT number to address the issue.

Resolution

Update Xcelsius 2008 version to SP2.

Keywords

incorrect, different, discrepant, null , KBA , BI-RA-XL , Dashboards and Presentation Design , Problem

Product

SAP BusinessObjects Xcelsius Enterprise 2008