SAP Knowledge Base Article - Public

3263115 - Data is not completely copied by Data Action script

Symptom

Not all of the data is copied by the Data Action script.

Environment

SAP Analytics Cloud

Reproducing the Issue

  1. Creating a Copy Data Action.
  2. Running the Data Action.

Cause

The data action script is set calculation scope which is in the hierarchy member & excluded Not in the Hierarchy member for processing. On the Source side, there is fact data with Not in hierarchy member, so it is excluded for data copy. Finally, the calculated result is only for in-hierarchy members and there is an inconsistency between Source and target value. 

Resolution

If you specify a hierarchy that doesn’t contain all the dimension members, the "Not in Hierarchies" member and its children are excluded from the calculation scope by default. To include these members, use the INCLUDE_MEMBERS_NOT_IN_HIERARCHY syntax:
CONFIG.HIERARCHY.INCLUDE_MEMBERS_NOT_IN_HIERARCHY [ModelName] = [d/DimensionName] 

Keywords

KBA , LOD-ANA-PL-DA , Data Actions , How To

Product

SAP Analytics Cloud 1.0