Not all of the data is copied by the Data Action script.
SAP Analytics Cloud
Reproducing the Issue
- Creating a Copy Data Action.
- Running the Data Action.
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.
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]
KBA , LOD-ANA-PL-DA , Data Actions , How To