SAP Knowledge Base Article - Public

3009675 - Unexpected results in advanced formula data action step when dimension contains multiple hierarchies in SAP Analytics Cloud for Planning (SAC)


Advanced formula step in data actions are not working as expected.

When executed at a parent level some values may be calculated but the total value does not match the expected sum of the child members.


  • SAP Analytics Cloud (Enterprise) 2020.20 and later releases


Issue occurs because one or more dimensions contain more than one hierarchy and the value expected by the end-user is from the non-default hierarchy.


To get the expected result add the CONFIG.HIERARCHY parameter in the advanced formula and define the hierarchy or hierarchies for each dimension with more than one hierarchy:

  •  CONFIG.HIERARCHY=[d/DimensionName].[h/Hierarchy],[d/DimensionName].[h/Hierarchy]

See Also

Your feedback is important to help us improve our knowledge base.


SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Sac, Acquisition, Model, Connect, Story, Tenant, Import, Failed, Using, Working , KBA , LOD-ANA-PL , Planning , Problem


SAP Analytics Cloud 1.0