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

Symptom

  • 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

 

Environment

  • 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

Cause

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

Resolution

  • Install Patch 3.5 of BI4.0

Keywords

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 , Dashboards, design-time, design on multi-source , Bug Filed

Product

SAP BusinessObjects Dashboards 4.0

Attachments

SAP_parent.xlf
SAp_child.xlf