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

Total Figures for shop based on list item mapped to other lists
Hello I have a calc module (CALC1) structured around a dummy list 1-20, plus a series of dimensions such as Region (1-3) and Shop Type (A-C), plus a timeline. This dummy list lays out a series of revenue adjustments over time based on the dimension categories, such as [+5% revenue for region 1, shop type c across periods…
Data Split between Many to Many Relationship Mappings
Hello Anaplan Community, I am encountering an issue with one of my development work and would be greatly appreciated your assistance. There are 2 different modules involved in my model: 1) INP01 Percentage Input by Product (Applies To: P3 List) 2) REP01 Percentage Split by Department (Applies To: Departments List) The…
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?