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

amit15
Occasional Contributor

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:

amit15_0-1623130532862.png

amit15_1-1623130592236.png

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
vinayvm
Certified Master Anaplanner

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

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

View solution in original post

4 REPLIES 4
vinayvm
Certified Master Anaplanner

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

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

View solution in original post

amit15
Occasional Contributor

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

Hi @vinayvm ,

 

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!

vinayvm
Certified Master Anaplanner

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

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
Occasional Contributor

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

Thank you @vinayvm. I will look into it.

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

 

regards,

Amit