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

31-Aug-17 1-21-18 PM.png

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'))

31-Aug-17 1-18-42 PM.png

Environment

  • SAP Analytics Cloud 2017.16

Cause

The usage of the "Calculate on details" feature is only supported with the following functions:

  • ABS
  • LOG
  • LOG10
  • POWER
  • DECFLOAT
  • DOUBLE
  • FLOAT
  • INT
  • EQUAL
  • NOT_EQUAL !=
  • GREATER >
  • LESS <
  • GREATER_EQUAL >=
  • LESS_EQUAL <=
  • AND 
  • OR
  • ADD +
  • SUB _
  • MULT *
  • DIV /

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.
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, 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 , modèle , impossible d'utiliser la "fonction , "fonction détail" dans les formules du m , détail" dans les formules du modèle , impossible d'utiliser la "fonction détai , detail, detailed details , 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) , Problem

Product

SAP Analytics Cloud 1.0