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]

• 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
• 2851317 - Where can I find more information on SAP Analytics Cloud (SAC) for Planning features and documentation?
• Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
• 2487011 - What information do I need to provide when opening an incident for SAP Analytics Cloud?
• SAP Analytics Cloud > Learning > Guided Playlists
• SAP Analytics Cloud > Learning > Guided Playlists > Getting Support
• Need More Help? Contact Support or visit the solution finder today!

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