Level 3 4.6.5 Sale Planning Model: DAT02 module

jeehui · 2023-11-28T06:11:17+00:00

There was an error rendering this rich post.

jeehui

I have tried to formulate the PY actual sales revenue as

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

Below is my screenshot for DAT01 whereby I imported the numbers from DAT05 in Datahub.

Below is my screenshot for DAT02 module:

However, I received a message that states "Format of mapping used for lookup doesn't match any dimension of the source".

I am not sure if it is because of my SYS03 format for A1 account is not correct or DAT02 dimension is incorrect.

Please advice. Thank you!

Accepted answers

VanshikaSingh

Please make sure following:

Apply Same dimension in DAT02 as in SYS03 then it will work.

Also Please check if you have following dimension in DAT 01 as well.

All comments

VanshikaSingh

@jeehui
you need not to apply Lookup: 'SYS00 Time Settings'.PY Qtr,

Apply:

DAT01 Baseline Financial Forecast'.Baseline Financial Forecast[LOOKUP: 'SYS03 Account>Product Details'.'P1 Product Family', LOOKUP: 'SYS03 Account>Product Details'.'G2 Country']

jeehui

Hi @VanshikaSingh ,

I have tried the above formula, but I still received the same error message.

VanshikaSingh

Please make sure following:

Apply Same dimension in DAT02 as in SYS03 then it will work.

Also Please check if you have following dimension in DAT 01 as well.

jeehui

Hi @VanshikaSingh ,

Thank you for the screenshot. May I ask why would I need G2 Country and P1 Product Family in DAT01? My DAT01 was importing data from DAT05 module in Datahub which does not have any of these dimensions.

jeehui

HI @VanshikaSingh ,

I managed to resolve this. Thank you!

Quick Links

Can you help?

Unanswered questions

Where can I find export file after running export process using machine task in a workflow?
I am testing export actions using workflow but its not generating any file when I am running the workflow, but the same process is generating export file when ran from the Actions→Process section. Is their any issue with the workflow functionality? Also, If I want to generate a file after completion of workflow and pull…
Automating Flat File Uploads to Anaplan Data Orchestrator (ADO) – Best Practices and Methods
Hello Anaplan Community, I am seeking guidance on the most effective ways to automatically upload flat files to Anaplan Data Orchestrator (ADO). Currently, our process involves loading flat files to an Anaplan Datahub using Anaplan APIs and custom Python scripting. With Anaplan Data Orchestrator's capabilities for data…
How to Design Simulation Planning in Anaplan with Multi-Level User Input and Step-by-Step Logging?
Hi Anaplan Community, I'm working on a simulation planning model where users need the flexibility to input pricing adjustments at any level of the product hierarchy, and I’d love your guidance on best practices. 📌 Scenario Overview: We have a 4-level product hierarchy: Brand Category Sub Category SKU (lowest level) The…