SAP Knowledge Base Article - Public

3428695 - SAC Data Action - Advanced Formula: CONFIG.HIERARCHY.INCLUDE_MEMBERS_NOT_IN_HIERARCHY not working

Symptom

The data action copies only datasets where the segment member is part of the hierarchy.
Using the setting CONFIG.HIERARCHY.INCLUDE_MEMBERS_NOT_IN_HIERARCHY, specifically due to the presence of a dataset with "Segment" = #, will not work as expected 
 
 

Environment

  • SAP ANALYTICS CLOUD

Reproducing the Issue

  1. Set a tracpoint within the advanced formula step " Copy Data".
  2. Run the trace of the data action.
  3. The calculation scope shows that # was not included.

Cause

The config setting "INCLUDE_MEMBERS_NOT_IN_HIERARCHY" only works on those dimension members that are included under the "not in hierarchy" node in the dimension.

Resolution

From the model change the value in the dimension in the menu "Empty Hierarchy Values" to "Group and show under "Not in Hierarchy. 

See Also

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, data action
 
, KBA , LOD-ANA-PL , Planning , LOD-ANA-PL-DA , Data Actions , Problem

Product

SAP Analytics Cloud all versions