Symptom
Not all of the data is copied by the Data Action script.
Environment
SAP Analytics Cloud
Reproducing the Issue
- Creating a Copy Data Action.
- 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