Conclusion of Level 2 Model Building DATA02 SKU Volumes module

Prithi · 2023-12-20T15:39:04+00:00

There was an error rendering this rich post.

hello

I'm stuck in this . can anyone help me

from Level 1 FP&A module we have G3 and P3 SKU as dimnesions where is when importing from supply chain module it has different dimensions . how to import ?

supply chain module

if i use DATA 01 begining inventory module as data source , can you help me in fixing the import as i am getting lots of errors

1 ) which year to choose as the data is in FY19 and FY20

can i get help where i am making mistakes or how it is done or imported ?

Accepted answers

Vamsi_Kaki

Hello @Prithi,

As mentioned, Pls import Volumes from Supply chain model to FP&A model.

The below snapshot of your Supply chain model shows DATA modules but please make sure you have created Demand modules where you calculate Monthly Demand Forecast by SKU and Location.

Please find in your model something similar to below snapshot

Here, I used "DEM04 Demand Export" as my Source module

All comments

Dikshant

@Prithi,

There are a few updates you can give a try.

Highlighted mapping to Column Header, and then go to the last line items tab and map Beginning Inventory to Volumes.

Also I feel your source module is incorrect. Ideally you must have a moduleDAT03 Historic Volume in Data Hub as well which has same dimensions to your module in SC Model.

Prithi

@Dikshant As you see DAT02 module has P3SKU , G3 location and time as dimension and where as in SC model DAT03 histrotic volumes has only P3SKU and Accounts dimensions , Location is missing . how we can import from it ?

Prithi

@Dikshant As you said I have tried importing from Histroic volumes. since the source module has model calendar FY20 , i will set the time to FY20 during import. it was successful but then it a error ; i have realised that bombay and mumbai has different names in location . so I thought of using code . so I have updated the line itmes in both FP&A and sc model with code and i have code to it as you see below and i try to import

Prithi

Prithi

but the whole table is empty 😥

Prithi

Why the mapping is not successful with codes ? why there is no code seen in the mapping table when importing ?

Dikshant

@Prithi DAT02 module does not have FY20. Update the time range to include that

Prithi

@Dikshant the DATA01 module doesnt have time dimension .

Dikshant

@Prithi,

Update for DAT02. Below is your screenshot and it has FY21. Your import action is importing the data into FY20 but since module does not has FY20 that's why import is getting ignored.

Prithi

so i should change the time to FY21 ?

Prithi

And also as you see there is error in imports . data code getting ignored ; can you please help me in this fully ?

Dikshant

@Prithi you need to update to FY20. then run the action.

Your target module does not have FY20 that's why import action shows ignored.

Vamsi_Kaki

Hello @Prithi,

As mentioned, Pls import Volumes from Supply chain model to FP&A model.

The below snapshot of your Supply chain model shows DATA modules but please make sure you have created Demand modules where you calculate Monthly Demand Forecast by SKU and Location.

Please find in your model something similar to below snapshot

Here, I used "DEM04 Demand Export" as my Source module

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.…