Highlighted
Occasional Contributor

Level 2 Sprint 2 DEM03 Growth Rate % line Item

 

For this line item, it is needed to align the dimensionality of the Source Module to Target Module, so that the Target Module can reference the Growth Rate % of the Source Module. See below for mapping reference:

Screen Shot 2020-06-30 at 4.41.32 PM.png

The issue I am having is that I am unable to properly map the formula. Resulting in various error messages.

I have been using variation of LOOKUP, and LOOKUP & SELECT functions, to no avail.

3 REPLIES 3
Highlighted
Contributor

Re: Level 2 Sprint 2 DEM03 Growth Rate % line Item

@Joh04924 I would say you are on the right path with "LOOKUP". Look at the mapping reference again, follow that exact sequence and check your logic.

 

DEM02 --> SYS08 --->DEM03

Highlighted
Occasional Contributor

Re: Level 2 Sprint 2 DEM03 Growth Rate % line Item

Thank you! 

Highlighted
Regular Contributor

Re: Level 2 Sprint 2 DEM03 Growth Rate % line Item

hi @Joh04924

You need to check the dimensions at source and target when using LOOKUP, so you see in source there is P1 and in target there is P3, so need a mapping between P3 and P1, so in the SYS module we get the P1 prod family for P3 SKU using PArent(parent()) , now based on the mapping, you can lookup values from dem02, so it will be dem02.lineitem[lookup:SYS08.Prod family]