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
- 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 "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
- 2511489 - Troubleshooting performance issues in SAP Analytics Cloud *** Master KBA ***
- How to find User Assistance for SAP Analytics Cloud?
- Have a question? Ask it here on the SAP Community. Or reply and share your knowledge!
- 2487011 - What information do I need to provide when opening incidents with SAP Analytics Cloud (Hint: Use component LOD-ANA*)
- SAP Analytics Cloud > Learning > Guided Playlists
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