Match data between two modules that have different dimensions

limjj

Hi,

I am trying to match data between two modules that have different dimensions.

The target module has the following dimensions.

And, the sourcing module has the following dimensions.

As seen above, the only difference is the time dimension. The Sourcing module has one Time dimension, but the Target module has two Time dimensions (Time and Month list).

Could you please help to match these two modules?

Thanks

AjayM

Ideally I would invest time in finding reason for the design, and clean it as needed. As mentioned, real time and custom time combination in a data module is not a sensible design.

Otherwise, you can follow this simple workaround to match the data:

1. Create a SYS mapping module to find real month item for each real year and 'month list' item combination (since this combination is dimensionality of the target module)

2. Using 'real month mapping' with LOOKUP, simply pull source module data into target module, but into a staging lineitem. At this point, your data between both the modules match. If you want this to be action driven, follow next step.

3. Create a saved view in the target module, using which, you can create an action to copy data from staging lineitem into required lineitem within the target module.

To reiterate, you should rather work towards maintaining an efficient solution design in the model. I'd encourage you to figure out the current design RC.

Cheers!