The delivered mapping
SDE_PSFT_InternalOrganizationDimension_DepartmentHierarchy_Derive has
a bug in it where it is incorrectly mapping the column
W_INT_ORG_DHS.ORG_HIER12_NUM to the wrong column.
Relevant area of the mapping is shown
here:
ORG_HIER12_NUM is connected to port
L13_NODE_LABEL (the L13 is correct even though it is connected to
HIER12).
If you look at the surrounding port
expressions around L13_NODE_LABEL, you will see that they are all
in pairs of VAR_LXX_NODE_LABEL and :LKP_W_PSFT_INT… but for L13_NODE_LABEL, it has :LKP instead of VAR.
So the fix is to change the expression
on L13_NODE_LABEL to:
No comments:
Post a Comment