Level 2 Sprint 2 DEM03 Growth Rate % line Item

Joh04924

 

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:

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.

AashcaJ

@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

Joh04924

Thank you! 

Kanishq17

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]

 

Tricia

@Joh04924  - were you able to resolve this? I am having the same issue.

 

Thanks!

neg177

Hi,

 

Were you ever able to figure out the Formula for the growth rate line item in Moduel DEM03?

augustus.perera

Hi

 

Please, need some help , I am passing the same passage.

 

IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN 'DEM01 Volume Growth Rates'.Growth %[LOOKUP: 'SYS08 SKU Details'.Product Family] ELSE 0

 

Context: Growth Rate Module P1 , DEM 3 Module has P3 and both P1,P3 are in SYS08

it brings no value.

 

 

augustus.perera

 refer weekly % module

augustus.perera

Hi appreciate some guidance ..both formulas don't bring any values

 

the DEM1 Module view

 

 

jjayavalli

 dem02.lineitem[lookup:SYS08.Prod family] it gives an error message, formula invalid.

Not sure what am I missing this time.

 

SRoberts

Looks like everyone has figured the correct SYS08 Product Family Lookup for this line, but recall that in a prior step we created DEM02 Volume Growth Rates by Week using formula 'MONTHVALUE('DEM01 Volume Growth Rates'.Growth %)' to bring the monthly value in DEM01 down to a weekly level.

 

My formula was successful when I accessed that weekly growth rate data.

jjayavalli

Hi, so are you suggesting to divide the MONTHVALUE/ 4 to get the weekly Growth %? I have used the Lookup Function here instead.

so wondering. Thank you:) 

mebby2k

'DEM02 Volume Growth Rates by Week'.Growth %[LOOKUP: 'SYS08 SKU Details'.Product Family]

Evahong

I have this problem too. Anaplan shows level mismatch on common dimension (attached screenshot). Are we missing on another dimension?

MKAnaplan

Having issues uploading DEM03 Growth rate. It's showing the % under Growth % instead of products.