In the description from '5.2 Model Build Specifications', we need to calculate the proportion of a country's total sales revenue by product family each account's product sales contributed. The TAR01 was created already in the model, it's dimentioned "A2 Account>Product#' only. However the first line item is to calculate PY Country and Product Family sales, shall I personally add another dimension 'G2 Country' to the module? I tried to calculate it by using DAT02 by referencing SYS03, it was incorrect in anyway "Level mismatch on common dimension". Please help!
@abhi1017 Appreciate your guidance. I added Product Family and Country as line items in TAR01, and tried the formula as you suggested, it still gives error 'Level mismatch on common dimension'...my DAT02 got two dimensions 'A1 Accounts' and 'P2 Product'.
Hey I was wondering if you can shed more light on the order of operations you used? When loading the historical data from the data hub into the sales planning model, should we be using the Account>Product list# and time as dimensions? Originally I created a DAT01 Historic Volumes Module and used Products & accounts as my dimensions. Then Loaded the requisite data into this module and used a lookup function referencing DAT01 in the DAT02 module.
Before I get too far - I'd like to ensure that my approach is correct. I see that you changed the dimensionality of the DAT02 Module to be the product # list, but I'm having trouble loading the original historic volume data into a module with only the numbered list dimension.
Hi @bleeds , when loading historic data, DAT01 is supposed to have the same dimension as the module in Data Hub; For DAT02, I used A2 Account>Product# as dimension, you can also use the same dimension with DAT01 but it would require more line items to be created (as @abhi1017 advised) and lookup those line items in TAR01 module.
If set the list A2 Account>Product# as dimension of DAT02, your approach is correct to reference DAT01 and lookup SYS00 & SYS03, by this way, it can facilitate some formulas in TAR01 module.
I know this is from a while ago, but this is flabbergasting to me....I did the equation and essentially you are doing a sum and lookup of the same 2 things. Ive seen sum lookups, but never Sum X Lookup X sum Y lookup Y. Any idea why that works?