SAP Knowledge Base Article - Public

2527989 - Details cannot be calculated on IF formula in SAP Analytics Cloud (BOC)

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

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

Product

SAP Analytics Cloud 1.0