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:
Best Answer
-
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
1
Answers
-
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!
0 -
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
1 -
Thank you @Vinay VaradarajM. I will look into it.
Also, I recreated the module and loaded data again. It worked. Thanks!
regards,
Amit
0