SAP Knowledge Base Article - Public

2616966 - Value doubled in formula that has a member in the formula which is a formula referring to another member in SAP Analytics Cloud (SAC)

Symptom

When two formula accounts are created of the type X=A*B, Y=C*D, and D is a formula of type "=A" then the value of Y will be twice the value of X

Environment

  • SAP Analytics Cloud 2018.4.0

Reproducing the Issue

Create account dimension members such as follows:

 

A01 Gross Sales
A0101 Regular
A010102 Quantity
A010103 Unit Price 
A0102 Special
A010202 Quantity
A010203 Unit Price
A04 Actual Amount

Formulas:

A0101 - [A010102]*[A010103]

A0102 - [A010202]*[A010203]

A010203 - [A010103]

Note that formula for A0101 and A0102 are essentially the same, but that A010203 is taking the value of A010103 via formula. This seems to cause the doubling of the value for A0102 when compared to A0101

Cause

This issue was due to an issue in the binary for the EPM code

Resolution

This issue has been resolved as of wave 2018.05

See Also

Your feedback is important to help us improve our knowledge base.
Please rate how useful you found this article by using the star rating feature at the beginning of this article.
Thank you.

Keywords

EPM, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics , KBA , LOD-ANA , SAP Analytics Cloud (SAC) , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predictive , Problem

Product

SAP Analytics Cloud 1.0