SAP Knowledge Base Article - Public

1716822 - Excel formulas using calculations based on a reference of another referenced cell are not displaying correct results when viewed in parent child dashboard / model in BI4.0


  • Incorrect data is displayed when viewing the Parent dashboard in BI Launchpad
  • Data is displayed correctly when displaying the child dashboard in BI launchpad
  • Issue is not present in Xcelsius 2008



  • Dashboard Design BI4.0 FP03

Reproducing the Issue

1. Open the attached SAP_child.xlf
2. Export to Enterprise
3. launch CMC and retrieve the CIUD of sap_child.swf
4. Open SAP_parent.xlf in Dashboard Design
5. In the SWF Loader, modify the CIUD to reflect the one from the CMC.
6. Export the parent model to BI Launchpad
7. Login to BI Launchpad
8. View the parent dashboard
==> the formula results in the last column  are incorrect


  • This issue has been identified as a Product Defect: # ADAPT01636061


  • Install Patch 3.5 of BI4.0


ADAPT01636061, 1636061, cumulative, formula, excel, cell, reference, formula based, dashboard design, Xcelsius, display, total, incorrect, wrong, parent/child, parent-child , KBA , BI-RA-XL-DSL , Obsolete: Design-Time, Design on Multi-Source , Bug Filed


SAP BusinessObjects Dashboards 4.0