Level 2 Conclusion : Importing from DEM04 into DATA02 SKU Volumes

rgarg25
Occasional Contributor

Level 2 Conclusion : Importing from DEM04 into DATA02 SKU Volumes

Hi,

 

I'm not getting errors as such but instruction says that there should be none ignored but in my case there are values in ignored. 

Can anyone help e find where I went wrong.

 

Regards,

Rajat

4 REPLIES 4
AntonMineev
Certified Master Anaplanner

Re: Level 2 Conclusion : Importing from DEM04 into DATA02 SKU Volumes

Hi, @rgarg25!

Anaplan ignoring a sum elements (H1 FY20, Nutzo Bar and etc.)

It is good practice to keep filters on the export view that hide the summing elements. So imports are faster and there is no ignoring of elements.

ChrisHeathcote
Community Boss

Re: Level 2 Conclusion : Importing from DEM04 into DATA02 SKU Volumes

@rgarg25 

The import process is automatically ignoring all the summary level items from lists and time.

Remove the list and time summary items from the saved view used to import the data.

Right click on the rows and select, 'select levels to show', deselect all summary levels and only show the lowest level items.

Do this for all lists.

For the time dimension use a time systems module to filter on months only ( or any other time frame ).

Save this and re-run the import.

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA
patelpn3
Contributor

Re: Level 2 Conclusion : Importing from DEM04 into DATA02 SKU Volumes

While exporting data, I am getting no data in SKU Code and Location Code columns. Can you please guide to figure out?

patelpn3_0-1625343856056.png

 

patelpn3
Contributor

Re: Level 2 Conclusion : Importing from DEM04 into DATA02 SKU Volumes

Never mind. works now!!