Updating Dimension Data via PAW Using Sets – Issue with Element Weights Not Copying

[PRAJAKTAGOLE]

Hi everyone,

I’m new to the forum and just getting started with Planning Analytics Explore. I’m currently working on a process to update dimension data from a source dimension to a target dimension using PAW. However, we don’t want to copy all elements—only a subset of accounts. For this, we’ve created a set.

The challenge we’re facing is that when we copy elements using the set, the associated consolidation weights are not coming through in the target dimension. Has anyone encountered this issue before? Is there a recommended way to retain or replicate weights when transferring dimension subsets in PAW?

Would appreciate any insights or tips from those who have worked on similar setups.

Thanks in advance!

[declanr]

Presumably in your TI process it is using the DimensionElementComponentAdd function (or HierarchyElementComponentAdd - the logic is the same) where you specify the parent and child elements that will form the relationship, the number at the end of that function is the weight which will be applied to the child in that instance.

Before doing that you can use ElWeight (or ElementWeight for hierarchies) to retrieve what the weight is in the source dimension e.g.

Code: Select all

nWeight = ElWeight ( cSourceDimName, sParentElement, sChildElement );
DimensionElementComponentAdd ( cTargetDimName, sParentElement, sChildElement, nWeight );