Symptom
DSUM function in the Xcelsius returns incorrect value
Environment
- Xcelsius 2008
- SAP BusinessObjects Dashboards 4.0
Reproducing the Issue
- Prepare the data cells in the spread sheet.
- Prepare the criteria of DSUM function in the spread sheet.
- Type DSUM function in the cell($J$1).
e.g. =DSUM($A:$I, $G$1, $A$2:$G$4)
- 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"))
- Insert Label Text component into the canvas and set the cell($K$1) as Link to Cell.
- Click Preview.
- 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
- Launch Xcelsius.
- Click File > Preferences.
- Click Excel Options.
- Set the value bigger than the row number of Excel in the Maximum Number Of Rows(Default value is 512).
- Close Xcelsius.
Keywords
ADAPT01683456, TE5000477937, cell, xls, column, excel, xlf, data range , KBA , BI-RA-XL , Obsolete: BusinessObjects Dashboards and Presentation Design , Problem
Product
SAP BusinessObjects Dashboards 4.0 ; SAP BusinessObjects Xcelsius Enterprise 2008