I have done till half of Sprint 3 and was checking my data back . I found my DAT03 Historic Volumes Module are missing the forecast years. It is having value only till year 2019 and nothing further
Earlier everything was working fine. Checked in history also , all looks good. Please let me know why this happened. I am worried as do I have to redo everything .
Regards,
Ankita
I have done till half of Sprint 3 and was checking my data back . I found my DAT03 Historic Volumes Module are missing the forecast years. It is having value only till year 2019 and nothing further
Earlier everything was working fine. Checked in history also , all looks good. Please let me know why this happened. I am worried as do I have to redo everything .
Regards,
Ankita
Is the Year 2020 missing only in one module or the entire model?. If it is missing in the entire model then most likely your Time Settings have changed and your future year might be showing as 0 instead of 1.
But if it is missing in only one module then it can be Hide/Show. Right Click on the module and click Show all.
It is missing in only one module DAT03 . I checked there is no hide columns. but due to this the value in DEM03 are not getting populated as it is based on 2020.
What to do ? Please help
Regards,
Ankita
Please check
Regards,
Ankita
If you had used Time Range in the module then it makes perfect sense.
But can you please tell why DEM03 Demand Forecast module gets the values for year 2020 and not for 2021.
Please check
Regards,
Ankita
I believe your current fiscal year of the model is 2020 which means you will store 2019 data as Historical data in DAT03 Historic Volumes. When you Offset these values by 52 weeks they will only populate 2020.
On the other hand If you have Historic Data in 2020 then 2021 will be populated as well because you are offseting the data by 52 weeks.
yes my fiscal year is dec19 - 20 . and historic data in 2019. so according to this am I all good to proceed further now or I am still missing out anything ?
Also if I go back and look at the activity in Sprint 2
Here DEM03 is having data in 2021 . I am not sure why I am not getting data.I am getting the data for 2020 but not for 2021. The formula I am using for baseline forecast is :
IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN 'DAT03 Historic Volumes'.'Offset Volumes for 1st Forecast Year' ELSE LAG(Default Forecast, -52, 0, STRICT)
Simple error, instead of -52 use 52 with LAG function. You should be able to see the numbers in FY 21 as well
Hurray got it fixed. So happy.Thanks a lot
Glad that it worked. Please close this query (along-with other queries) by marking it as solution accepted