SAP Knowledge Base Article - Public

3010830 - Unexpected results in advanced formula data action step - SAP Analytics Cloud


Advanced formula step in data actions is not working as expected if there is any dimension with hierarchy, where for an existing member of this dimension, the hierarchy is not filled (blank).


SAP Analytics Cloud (SAC) 2020.21 and later releases


The behavior of "Not in Hierarchies" member had been changed. Previous, it was included in calculation scope, but  it is excluded from the calculation scope by default.


To get the expected result add the CONFIG.HIERARCHY.INCLUDE_MEMBERS_NOT_IN_HIERARCHY parameter in the advanced formula as below:


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, DA, AF, formula, trigger, #, blank, Not in Hierarchies, Hierarchy, Hier , KBA , LOD-ANA-PL-DA , Data Actions , Problem


SAP Analytics Cloud 1.0