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:
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.
Answers
-
Thank you!
0 -
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]
3 -
Hi,
Were you ever able to figure out the Formula for the growth rate line item in Moduel DEM03?
0 -
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.
0 -
refer weekly % module
2 -
Hi appreciate some guidance ..both formulas don't bring any values
the DEM1 Module view
0 -
dem02.lineitem[lookup:SYS08.Prod family] it gives an error message, formula invalid.
Not sure what am I missing this time.
0 -
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.
0 -
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:)
0 -
'DEM02 Volume Growth Rates by Week'.Growth %[LOOKUP: 'SYS08 SKU Details'.Product Family]
1 -
I have this problem too. Anaplan shows level mismatch on common dimension (attached screenshot). Are we missing on another dimension?
0 -
Having issues uploading DEM03 Growth rate. It's showing the % under Growth % instead of products.
0