Level 1 Model Building Training
Hi,
In Level 1 Model building Training, i have created an input Module as follow
The next step asks to import the data to this module, as given below
When i am trying to import the data, what should i map the 'Volumes' line item to??
Best Answer
-
HI,
Choose Fixed line item option from the dropdown, then go to the Line item tab and select volume line item.
~Vignesh M
2
Answers
-
Got it, Thanks!!. realized now that my issue was with time format again, not line item.0
-
Your excel contains YYYYMM time format, you can use periods options to map the time.
Use it either Y-M option or YYYYMM.
Regards,
Vignesh M
0 -
Hi
Quick question on the same topic, when i tried to load it, I do as described above, but i get 52,152 fails, and 26,076 success.
Looking at the view log i get the line Invalid period for format YYYYMM: 202001, Invalid period for format YYYYMM: 202002 etc a lot. Have I not setup the time periods correctly, i only see 2019
0 -
0
-
No, I only seem to have 2019 as a valid year. How do I change that?
I checked all my 2019 data and it's perfect, it is just the future years.
0 -
Look where you setup how many years that are in your model...Look in the Time Settings area.
0 -
I think that is my main problem.
i am not seeing how to make more years, than the current.
i see mention of model calendar in Time range, but don't know how to modify it
0 -
0
-
Thanks, I worked it out, just after my last post.
0 -
Do you have to make any changes to the options on the right as well?
0 -
I am going through Level 1 training as well.
I could successfully import the data for this module, however, I see the totals across the cells, instead of individual numbers.
Here is the mapping I used
I can see the data as expected in the preview as shown above. When i import the data, I see a totals for each product (?) all across as shown below. Can you please help ?
0 -
@PG In the import settings, have you further looked into the time settings. Make sure you match the source format (201901) and target (Jan 19).
0 -
Thanks Satyam!
Please see the time settings I have used below. I have used 'YYYYMM' - which I thought would line up with 201901 and so on. Should I be selecting something else ?
0 -
@PG that seems fine. Can you also share a screenshot of your line items?
0 -
Please see all the relevant screenshots. Thank you!
0 -
Thanks @PG. Your line items seem to have a subsidiary view (you will learn this in future lessons) - that grid icon you see after volumes in the first screenshot shouldn't be there. Basically what a subsidiary means/grid icon appears when your dimensionality for that specific line items varies from your overall model setting (time, version, lists).
You can read more about it here - https://help.anaplan.com/anapedia/Content/Modeling/Build%20Models/Subsidiary_Views.html
Try to find out now by looking into this module carefully. Attached is a screenshot for mine if it helps.
1 -
Thank you ! Is there an easy way to remove subsidiary view ? Sorry if I missed it in the link you sent.
0 -
what you can do is create a new (test) module rev02 and test. By default, it doesn't create a subsidiary view when you create a new module. If works, you can delete the subsidiary view one.
1 -
Thank you! I have created a new module and deleted the old one.
0 -
Good, did you get the desired result?
0 -
Yes, the data now shows up as expected. Thank you!
1 -
Hi Guys,
I am having the same problem on 10.2.2 Activity: Import Data into Non Employee Expenses Module
the Time settings isnt working and I dont understand why because I put in YYYYMM
0
