Level 3 Model Building Sprint 1: TAR01 Detailed Sales Target module

NadiaSafarah · 2023-10-30T07:42:50+00:00

There was an error rendering this rich post.

I'm working on my L3 Model Building, It has been paused for quite sometimes due to my confusion in how to fill The TAR01 Detailed Sales Target module. I can't even create a module to verify the The TAR01 Detailed Sales Target data.

Here is the TAR01 Detailed Sales Target module that have been filled

Here are the formulas I used in the line items

'PY Country and Product Family Sales' = 'TAR01 Sales Target'.Baseline Financial Forecast[LOOKUP: 'SYS03 Account>Product Details'.'G2 Country', LOOKUP: 'SYS03 Account>Product Details'.'P1 Product Family']

'Initial Country Sales Target' = 'TAR01 Sales Target'.Initial Country Sales Target[LOOKUP: 'SYS03 Account>Product Details'.'G2 Country', LOOKUP: 'SYS03 Account>Product Details'.'P1 Product Family']

'PY Account Revenue' = 'DAT01 PY Revenue'.Revenue[LOOKUP: 'SYS03 Account>Product Details'.'A1 Account', LOOKUP: 'SYS03 Account>Product Details'.'P2 Product', LOOKUP: 'SYS00 Time Settings'.PY Qtr]

'PY Account / PY Country Product Family' = PY Account Revenue / 'PY Country and Product Family Sales'

'Initial Account Sales Target' = Initial Country Sales Target * 'PY Account / PY Country Product Family'

I believe I got 'Initial Country Sales Target' right, but I'm not so sure about the others. Especially, the 'Initial Country Sales Target', I think I got the wrong source. I've tried everything, by making new module that collected the PY revenue from DAT01 with the dimensions of 'A2 Account>Product#' and also the module that using the dimensions of G2 Country and P2 Product and sum it by P1 Product Family at the end but the numbers still doesn't working. I don't even think my formulas for 'PY Account / PY Country Product Family' and 'Initial Account Sales Target' are right either. Please help me with this😭this will be due in 3 days.

And I also had no idea on how to verify the value of the module, I followed the instructions and create the module using G2 Country, P2 Product and Quarter as dimensions. And I've tried to summed the 'PY Account / PY Country Product Family' by Product Family which obviously wouldn't working.

So I can't even verify that TAR01 Detailed Sales Target module that had been filled. Guys please help me on both modules ('TAR01 Detailed Sales Target' and 'Verify TAR01 Detailed Sales Target')😥😭I'm so clueless and it will due in 3 days…

Accepted answers

All comments

Vamsi_Kaki

Hello @NadiaSafarah , here your target line item "verify" has "G2 Country and P1 Product Family" as dimensions. Hence, mappings should be written for both dimensions. But, you included only Product Family.

Moreover, you are aggregating data from TAR01 module which is dimensioned by "A2 Account>Product#". Hence, consider properties of the list in the mappings

Thanks,

Vamsi

Quick Links

Can you help?

Unanswered questions

Curious Comparison: Forecast Modeling for Unusual Products
I've been experimenting with some forecast modeling techniques in Anaplan recently and decided to test them on a few quirky, offbeat product categories just for fun. One of the categories I played around with was love dolls—yes, you read that right. It actually turned out to be more interesting than expected. Unlike…
OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…