Level 3 Establishing Sales Targets - TAR01 Detailed Sales Target module

Seen a question regarding TAR01 Detailed Sales Target module, I still have doubts though. In this Module there is a line item "PY Country and Product Family Sales" this value is to be fetched from DAT01 PY Revenue to CY, however there is no hierarchy between Country & Accounts in the training so far. I assume we have to create one, or am I missing something?

Accepted answers

All comments

Kanishq17

Hi , there is a country and product family hierarchy and account have relation to country and prod family , so we can reference that relation

ShanthiVish

Thanks @Kanishq17 , I approached it differently using SUM function and also changing the dimensions in "TRA01 Detailed Sales Targets" replaced the default suggested with Accounts, Country and Product Family. It works , though Country & Product Family values repeat for every Account. I also created a staging module.

Thanks for taking time to reply.

Quick Links

Can you help?

Unanswered questions

Alternative of Rankcumulate
Is there an alternative to using RANKCUMULATE in Anaplan for cumulative ranking by group? The model's performance is impacted due to the use of rankcumulate. I'm looking for a more efficient approach or best practice to achieve cumulative ranking within groups without degrading performance.
Azure blob connection Cloudworks vs ADO
I am trying to connect to Azure blob, the credentials work on cloudworks, but do not work on ADO. Has anyone else experienced this issue?
Berapa nomor Tokopedia?
Tokopedia Menyediakan layanan WhatsApp? Untuk menghubungi layanan Tokopedia melalui (WA)62_08174_9080_16 kamu bisa mengikuti.