2448851 - Formula calculation (calculated account / measure) using Details() is not refreshed and / or causing poor performance in SAP Analytics Cloud

SAP Knowledge Base Article - Public

2448851 - Formula calculation (calculated account / measure) using Details() is not refreshed and / or causing poor performance in SAP Analytics Cloud

Symptom

  • Formula calculation (calculated account / measure) using Details() is not refreshed and / or causing poor performance in SAP Analytics Cloud (formerly known as SAP BusinessObjects Cloud / BOC)
  • The calculated values only appear when new values are planned (that is, after data input).
  • The formula uses the "Calculate on" / Details() feature.

Example:

Details([Account1]*[Account2])

CalcOnDetails.png

Environment

  • SAP Analytics Cloud 2017.17.1

Reproducing the Issue

Open a story with a table referencing the formula account and notice account / key figure is not refreshed properly.

Once data is entered, the measure is calculated.

Resolution

Do not use the formula with the "calculate on details" feature / 'Details()' keyword as it  will be deprecated / not supported in the future.

Instead add the exception aggregation 'SUM' with all required dimensions as exception aggregation dimensions.

See the following article on Exception Aggregation in SAP Analytics Cloud: Applying Aggregation in SAP Analytics Cloud.

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, Hana Cloud for Planning, EPM-ODS, Cloud for Analytics, C4P, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, HCP, C4A, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJ, BOBJcloud, BOCloud., BICloud, BO Cloud, connecting, conecting, conectando, conexão, modelo, SBOC, Details cannot be calculated on IF formula , KBA , LOD-ANA , SAP Analytics Cloud , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , How To

Product

SAP Analytics Cloud 1.0