Based on Dimension A means using lookup on Dimension A. Let's say the dimension values used in the MOD02 are mapped to Dimension A items say C1 is mapped to B1 and C2 is Mapped to B2 and C3 is mapped to B3. So in MOD02 I want to use the value in the current period i.e., JUN20 the value of line item MOD01.x for period JAN19 but if the dimension in MOD02 is C1 it should take the Value from MOD01.x for period JAN19 for B1 and so on.
And It is not the previous year's value. It could be for any period. Jan19 ==> JUN20 or Jan19 ==> OCT20.
Maybe because I'm a visual person, I use a very systematic way to figure out the construct of my LOOKUPs.
Identify the dimensions of the Source Module. These are the values you have to pass in your LOOKUP formula ==> for example dimension A
Review the dimensions available to you in the Target module.
If you have dimension A in the Target, then you don't need a lookup (that's obviously not your case)
If you have a different dimension in the Target module, such as B, then you have to look for a mapping module that is dimensioned by B (same as Target module) and have a list formatted line item of type list A.
I try to provide an unbroken link between my Source and Target modules where the output (or return value) of one module serves as the input to the next module in the link until I reached my final Target module.
You are probably explaining your issue fine, but I am not able to visualize it. If you break down the problem by
First, identifying what you need to do from a 'business" perspective - For Example, I need to retrieve the Product size to my Target module.
Identify which module has the size data line item you are trying to retrieve
Then start constructing your LOOKUP link
You obviously have the complication of the different Time value between your source and target. How are you determining if Jan 19 should go to Jan 20 or Oct 20 for example? If you are using a mapping system module then you can do a LOOKUP as well.
Einas "Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"
The determining factor of whether jan19 data goes to jun20 or oct20 depends on when the entity in List A joins. I have the mapping module and offset value. The Only issue is I am unable to look up and offset at the same time.
I have the offset value in mod02 which gives the difference of period in Mod02 and Mod01 i.e., for Jun20 offset = 17 now I need something like Mod02.required result = offset(mod01.x[lookup:'Mapping module'.map_to], offset_value, offset_value+1)