Exports
For each export there are two columns that will need to be mapped to the custom properties for the target dimension:
-
Column: TARGKEY – The name of the node being mapped to in the target dimension.
-
Column: TARGETDIMENSIONNAME – The dimension name of the target dimension.
The property used to get the Target Key Name cannot just use a formula of ParentProp(). This is because you may map at a rollup point from the ERP dimension. The logic for this property should continue up and return the first node name found that is a true target dimension node. For example:
