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 calculations (calculated account / measure) using Details() is not refreshed and / or causing poor performance in SAP Analytics Cloud (SAC).
  • 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])

Environment

  • SAP Analytics Cloud

Reproducing the Issue

  1. Open a story with a table referencing the formula account and notice account / key figure is not refreshed properly.
  2. Once data is entered, the measure is calculated.

Resolution

  • Do not use the "calculate on details" feature / 'Details()' keyword as it will be deprecated / not supported in the future. See Attributes of an Account Dimension.
  • 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, 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, accounts, measures, , KBA , sac , 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 , How To

Product

SAP Analytics Cloud 1.0