I am currently working on the Level 2 Sprint 2 2.3.10 Activity: Create Demand Forecast.
In this activity, I need to create a formula which takes weekly growth rates by Product Family in one module and populate them by Product (child of product family) in another module. There is a third module which includes both dimensions.
My thought process is this:
Populate DEM 03 Demand Forecast's Growth Rate % (by Product) by referencing DEM 02 Volume Growth Rates By Week's Growth Rate % (by Product Family) by looking up the SYS08 SKU Details module which contain both in adjacent columns.
However:
'DEM02 Volume Growth Rates by Week'.Growth %[lookup: 'SYS08 SKU Details'.Product]
results in:
"Level mismatch on common dimension"
and
'DEM02 Volume Growth Rates by Week'.Growth %[lookup: 'SYS08 SKU Details'.Product Family]
results in:
"Dimension of mapping used for lookup doesn't match any dimension of the result"
How do I get Anaplan to translate the growth rate using SYS08?