Level 3 4.6.5 Sale Planning Model: DAT01 module

Hi Community,

I was wondering if I did my DAT01 correctly? Because to import DAT05 historical sales from Datahub to Sales Planning module, I will need to set both dimensions as A1 Account and P2 Product list.

However, when I start to build DAT02, my dimension was A2 Accounts>Product list (according to the learning module)

Hence I keep getting the error message that my format of mapping doesn't match.

May I get some guidance here?

Below is my screenshot of DAT01 with dimensions A1 Account, P2 Product.

Accepted answers

Ashutosh

Yes, You will get your data is correct. Just you need to create a system module between your Hierarchical list A2 Accounts>Product list and Flat list. Then u can use lookup to pull the data from PY to Current year by using lookups.

Hope that Helps.

Thanks

Ashutosh

jeehui

Hi @Ashutosh ,

Thank you for the reply!

I managed to resolve this.

All comments

Ashutosh

Thanks

Ashutosh

jeehui

Hi @Ashutosh ,

Thank you for the reply!

I managed to resolve this.

Quick Links

Can you help?

Unanswered questions

Sorting General List
Hi, I wonder if there's a way I can sort my general list alphabetically. The list is used as a drop down menu in a line item module and I want the drop down menu to be easy to navigate. I've already tried the Order List action. I already have a module with a text-formatted line item based on that list. But when I try to…
Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
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.…