Level 1: 8.5.3 Activity- Unable to import data in Volumes module

Hi Guys,

I am unable to load data in Volumes. The issue is that file is loading sum of all the columns into single month.

e.g. in Jan'19, data for Jan'19 from file should load, but it is first summing up data from Jan'19 till Dec'21 and then adding that number in Jan'19. Same process repeats for all months.

Can you please help where I am missing? Attached is the file and screenshots. I think something is wrong with Time mapping but not sure what.

Import Setting:

Volume+Inputs_110715.csv

Accepted answers

Vinay VaradarajM

Hi @amit15 ,

From the 2nd screenshot, it seems that there is a dimension mismatch between the source and target (as a subsidiary view can be seen on Volumes line item. I suggest the dimensions be set right in the target (Product, Location, Time), and retry importing.

Regards,

vinayvm

All comments

Vinay VaradarajM

Hi @amit15 ,

Regards,

vinayvm

amit15

Hi @Vinay VaradarajM ,

Can you please help me understand more on this subsidiary view? How it got enabled and how can we avoid it? This is also confusing me. Thanks!

Vinay VaradarajM

Hi @amit15 ,

A subsidiary view is created when the dimensions of a lineitem are different when compared with the Module dimensions.

You might want to refer this 4 minute video which explains the details.

https://community.anaplan.com/t5/On-Demand-Courses/Subsidiary-Views/ta-p/63627

Regards,

vinayvm

amit15

Thank you @Vinay VaradarajM. I will look into it.

Also, I recreated the module and loaded data again. It worked. Thanks!

regards,

Amit

Quick Links

Can you help?

Unanswered questions

Not Able to Join the Level 1 Model Building Course
Hey Everyone, I was trying to learn about the Level 1 Model Building Course, when i log in to my system and click on "Start the course" option its showing training unavailable, Can anyone please help me with this @Dikshant and all?
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…