Symptom
The following error occurs in the SAP Analytics Cloud modeler when saving a formula with the "Calculate on details" feature / 'Details()' keyword:
- Details cannot be calculated on IF Formula
This error may also appear when you open a story referencing an account / measure that uses the "Calculate on details" feature / 'Details()' keyword:
- An error occurred while executing the query. No changes were made and the previous state is now restored.
- Caught exception: exception 70034011: Inconsistent calculation model\$message\$=Inconsistent calculation model;calculationNode (N_0007_AGR) -> attributes ->attribute
(R_[sap.epm:Account].[parentId].&[Round]__SignedData) -> expression:Expression is not valid: Evaluator:type error in expression evaluator;fixed16_24.7 fixed_16([here]round(fixed16_24.7 "R_[sap.epm:Account].[parentId].&[700000]__SignedData",decfloat '2'))
Environment
- SAP Analytics Cloud
Cause
The usage of the "Calculate on details" is deprecated / not supported.
Resolution
- Do not use the formula with the "Calculate on details" feature / 'Details()' keyword as it will be deprecated / not supported.
- 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
- 2448851 - Formula calculation not refreshed in SAP Analytics Cloud
- Price * Volume Formulas
- 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.
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, SAC, SAP BusinessObjects Cloud, Business Objects, SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics , KBA , calculate on details , impossible d'utiliser la "fonction , détail" dans les formules du modèle , impossible d'utiliser la "fonction détai , "fonction détail" dans les formules du m , modèle , detail, detailed details , 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