SAP Knowledge Base Article - Public

1825063 - DSUM function in the Xcelsius returns incorrect value

Symptom

DSUM function in the Xcelsius returns incorrect value

Environment

  • Xcelsius 2008
  • SAP BusinessObjects Dashboards 4.0

Reproducing the Issue

  1. Prepare the data cells in the spread sheet.

data.jpg

  1. Prepare the criteria of DSUM function in the spread sheet.

condition.jpg

  1. Type DSUM function in the cell($J$1).

e.g. =DSUM($A:$I, $G$1, $A$2:$G$4)

  1. Type the following function to check the result of DSUM function in the cell($K$1).

e.g. =IF($J$1="","",IF($J$1>0,"Correct","In Correct"))

  1. Insert Label Text component into the canvas and set the cell($K$1) as Link to Cell.
  2. Click Preview.
  3. The Label Text shows "In Correct".

 

Cause

When the row number of Excel is bigger than the value of Maximum Number Of Rows, the excess rows will be abandoned at run-time.

Resolution

  1. Launch Xcelsius.
  2. Click File > Preferences.
  3. Click Excel Options.
  4. Set the value bigger than the row number of Excel in the Maximum Number Of Rows(Default value is 512).
  5. Close Xcelsius.

 

Keywords

ADAPT01683456, TE5000477937, cell, xls, column, excel, xlf, data range , KBA , BI-RA-XL , Dashboards and Presentation Design , Problem

Product

SAP BusinessObjects Dashboards 4.0 ; SAP BusinessObjects Xcelsius Enterprise 2008