SAP Knowledge Base Article - Public

3010830 - Unexpected results in advanced formula data action step - LOD-ANA-PL

Symptom

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

Environment

SAP Analytics Cloud (SAC) 2020.21 and later releases

Cause

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.

Resolution

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

CONFIG.HIERARCHY.INCLUDE_MEMBERS_NOT_IN_HIERARCHY = [d/DimensionName]

See Also

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

Keywords

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 , KBA , LOD-ANA-PL-DA , Data Actions , Problem

Product

SAP Analytics Cloud 1.0