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!

rob_marshall

why do you need the month dimension along with Time?

limjj

Actually, I have another module that has Time + Month list which is the final target module. That is why I want to copy the data of source module to the target module that has the same Time dimension with the final target module.

AjayM

1. Time dimension (Year level) and 'Month list' together in a module doesn't make sense. Why not have time dimension (Month level) alone in that module, similar to the source module?
2. If source module has one lesser dimension than that of the target module, you would need a lineitem within the source module that is of that extra list format (here, 'Month list' format) and with some meaningful mapping between other dimensions. With that, you can either use an import action or even write a formula to pull data into target module.

Cheers!

limjj

Thank you for your response. The model I am working on was built by someone who is no longer here, so I do not know the purpose of combining the Time dimension with the Month list. This is also why I did not want to modify the structure of the current modules.

limjj

Thank you for the answer. It works well!

I appreciate it.

Best