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
data action, syntax, advanced formula, data inconsistent, include all members, select different hierarchies, mapping, cross model copy not working, DELETE clause not working, unexpected result, data incorrect, include members not in hierarchy, how to include all members not in hierarchies , KBA , LOD-ANA-PL-DA , Data Actions , LOD-ANA-PL-AF , Advanced Formulas , How To
SAP Knowledge Base Article - Public