- 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.
- 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.
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.
- Help portal
- SAP Community network portal ( Questions & Answers / Direct Link to Create Question / Blogs )
- SAP Community WIKI
- Ideaplace forum ( for enhancement requests & new features )
- Watch these videos to help start your journey with SAP BusinessObjects Cloud
- Training videos by topic areas: ( Overview, What's New, Models and Connections, Stories, SAP Digital Boardroom, Planning, Predictive, Collaboration, Administration )
- Training Events
- Past Event Recordings
- New user handbook
- How to connect to on-premise data
- Introducing SAP BusinessObjects Cloud: BI and Planning (SAP Press book)
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.
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