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??
Go to Solution.
Choose Fixed line item option from the dropdown, then go to the Line item tab and select volume line item.
View solution in original post
Your excel contains YYYYMM time format, you can use periods options to map the time.
Use it either Y-M option or YYYYMM.
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
Look to see what years are in your model. Is 2020 a valid year?
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.
Look where you setup how many years that are in your model...Look in the Time Settings area.
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
Go to where you set up the Time for the model, not the module.