Level 3 TAR01 Detailed Sales Target

Hi Community,

Needed some advice here.

I understand that in order to get the PY Country and Product Family Sales amount, I will need to use PY actual sales sum by country and product family.

However, how can I get the actual sales by country and product family when both my DAT01 PY revenue (imported from DAT05 in datahub) & DAT02 only has accounts & products dimension? I have tried added G2 Country and P1 Product family dimension, but I encounter error mentioning that there is a mismatch.

Accepted answers

All comments

drishtibanga

Hi @jeehui
In order to get data in Module DAT01 Baseline financial forecast (Spoke model) which should dimensionalized by Country & Product Family, you can download & Import the csv file attached to course of L3 (Specifically Sprint 1> User story 1.1 > lesson 2.2 > Model Building specification.

Hope this will help. Thanks

jeehui

Hi @drishtibanga ,

Yes, I have my Baseline Financial Forecast import from the above CSV file, with both G2 country and P1 Product Family as my dimensions.

However, in order to get the PY Country and Product Family Sales amount in TAR01 Detailed Sales Target, my solution was to reference to the prior year actual sales, which was DAT02. But I encountered a message while trying to reference to DAT02, which states that the dimension cannot be match.

drishtibanga

Kindly rename your module TAR01BaseLine Financial Forecast to DAT01Baseline Financial Forecast (Dimensionalized with Country & Product fAMILY)
You are referencing TAR01 To DAT02 which is not correct.
Create another Module DAT03 PY Actual Sales Revenue dimensionalized by Flat Product list & A1 Accounts.
Import data from DH to Module DAT03.
Insert formula in DAT02 and take ref from DAT03. Hence formula should be 'DAT03 PY Actual Sales Revenue'.Revenue[LOOKUP: 'SYS03 Account>Product Details'.'A1 Account', LOOKUP: 'SYS03 Account>Product Details'.Product Flat, LOOKUP: 'SYS00 Time Settings'.PY Qtr]

Hope this helps!

jeehui

Hi @drishtibanga ,

Thank you for the detailed steps. Yes, I have completed the above since the above was to build 4.6.5 of Level 3 Sprint 1.

But currently I am stuck at retrieving the PY Country & Product Family Sales in TAR01 Detailed Sales Target.

drishtibanga

You can create one new calculation module CALC01 dimesionalized by Country & Product family. Create a line item their, have data from DAT02 by using SUM.

Ref: 'DAT02'.CY Revenue[SUM: 'SYS03 Account>Product Details'.'G2 Country', SUM: 'SYS03 Account>Product Details'.'P1 Product Family']
Use CALC01 & have the formula in TAR01.

Ref: 'CAL01'.'PY Product & Country'[LOOKUP: 'SYS03 Account>Product Details'.'P1 Product Family', LOOKUP: 'SYS03 Account>Product Details'.'G2 Country']

Hope this helps!

Dikshant

@jeehui,

Steps mentioned by @drishtibanga are correct, and the rationale behind this is that first you sum up your CY revenue at G2 Country and P1 Product Family Level. And then lookup the same numbers for the respective account, as each A2 Account>Product in the TAR01 module belongs to a G2 country and a P1 product family in the system module.

Quick Links

Can you help?

Unanswered questions

Poll: Should I have a single model or two separate models?
Hi Anaplanners, I am hoping to collect some feedbacks from you on an ongoing discussion I've been having with my stakeholders. My organization currently have 1 TQP model, which is focused on keep the model small and agile, and quick enough for about 200 managers to use to plan out their territories within a 5 weeks…
Need Help: Import Updates Only Specific Combinations Without Erasing Others
Hi Anaplan Community, I'm facing an issue while importing data (text details) into a module that has two dimensions: "Unique Line ID" and "Organization x Site". The source file is based on a numbered list. It includes text-formatted columns (line items) that contain the names of the "Unique Line ID" and "Organization x…
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…