Hi,
When I download the L3 Sales Planning Model, the 'SYS02 Account Details' module is pre-filled with data, but it doesn't match with the data in the Accounts csv file/Hub/A2 List*.
[NB : *the csv file is not necessary in Level 3 as data can be imported from the Data Hub built in level 2. However, the data in the data Hub was imported from the same csv file. So, when I refer to csv file, this is also true of the data in the Data Hub or in the Compound List A2 Account>Product]
For example : in SYS02, Cochocolate** is assigned to code 'A109', Location Venice (and therefore mapped to Country 'Italy') whereas Cochocolate is assigned to G012 Location (=Rio de Janeiro) in the csv file (see screenshot or table below).
Cochocolate_line_item | SYS02 | csv_file/Hub/A2_Acc>Prod |
|---|
Code | A109 ❌ | A132 ✅ |
Location | Venice (→ Italy) ❌ | G012 (Rio → Brazil) ✅ |
[**when I downloaded the model another time, Cochocolate was yet with another Code so it seems that the initialisation of the Model is not stable for SYS02 (us1).]
As a result, the 'Country' mapping was not correct and:
- My results couldn't match those for the "Check your results" starting from User Story 1.5 (> TAR01 Detailed Sales Targets > Line item : PY Country and Product Family Sales).
- I've realized that the 'Segment' line item in SYS02 is erroneous as well, so the 'Check your work' from User Story 1.7-1.10 is not possible neither. And here, we don't have a csv file with the correct 'Segment' to fill in SYS02. To solve this, I need to compare my result country by country with the 'Check your work' (Italy is given, for the others it will take some time to change the segments size in SYS02 in order to match the picture).
I hope this post will help others who have experienced the same issues. I will add the csv file with the account/segment mapping once it is ready.
