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:


export example