Level 1 Model Building : Question on DATA01 Module

This question concerns part 11 of the Level 1 Model Building in Activity "Create a profit and loss model". I have a big import problem for the P&L+Actuals+&+Budget.csv because beyond the Actual,UK,Utilities line, nothing goes beyond that in the import (i.e. 2/3 of the data is missing in the import). I checked the validity of the data, the mapping and nothing solves my question. Has anyone encountered a similar problem and would they know how to help me?

Accepted answers

usman.zia

Hi @edgar.minault

The module for the data that is imported should have the following dimensions:

DAT01 P&L Actuals and Budget Dimensions: G2 Country, Versions, Time (Months)

The line items should be:

Headcount
Revenue
Cost of Sales
Salary
Bonus
Car Costs
Phone Costs
Medical Costs
Shipping Costs
Rent
Utilities
Shared Costs

I would check that these are correct first.

Then I would check the time settings of the model and make sure that the range is correct.

Then I would check that the version in the import is actual and there is no switchover applied.

Then I would check the data in the import file to make sure nothing is missing.

If this all fails please coud you provide a screenshot of your import that you have created.

I hope this helps!

Thanks,

Usman

All comments

usman.zia

Hi @edgar.minault

The module for the data that is imported should have the following dimensions:

DAT01 P&L Actuals and Budget Dimensions: G2 Country, Versions, Time (Months)

The line items should be:

Headcount
Revenue
Cost of Sales
Salary
Bonus
Car Costs
Phone Costs
Medical Costs
Shipping Costs
Rent
Utilities
Shared Costs

I would check that these are correct first.

Then I would check the time settings of the model and make sure that the range is correct.

Then I would check that the version in the import is actual and there is no switchover applied.

Then I would check the data in the import file to make sure nothing is missing.

If this all fails please coud you provide a screenshot of your import that you have created.

I hope this helps!

Thanks,

Usman

antonlagergren

Hello,

I am having the same issue. The cvs file does not upload past about row 60. There are 289 rows, so I am missing huge chunk of data.

I have gone through all the check steps you posted, but still having no luck.

Attached are my screenshots.

Thank you,

Anton

Profit_Loss_Screenshot_Module_11_Anaplan_Level_1_65267.JPG

Where_it_stops_65267.JPG

antonlagergren

Actually I think I solved my own problem. I realized I have not worked with data this large before and that not all data will show in the preview screen.

Also, because of the view I was in (probably could mess around in pivot to show everything), I was not seeing budget data since I had time as a column I had to scroll very far to the right to see the data.

So infact this was a good exercise in learning to double-check that your data is imported by paying attention to exactly how it imports and what view you are in.

Quick Links

Can you help?

Unanswered questions

How to create identical child items for multiple parents
The data I'm trying to import is as follows Parent-Code A B A C B D C D D E I want to generate the following list from this data: L1 L2 L3 L4 A A-B A-B-D A-B-D-E A A-C A-C-D A-C-D-E You can create up to L3.However, L4 has multiple parents for one row of data When I try to create L4 from D-E, only one list row is generated…
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.…