Sprint 3 Dat03 Historic Volumes

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

ankitaga2000_0-1616411661566.png

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

Comments

  • @ankitaga2000 

     

    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.

    ankitaga2000_0-1616413128450.png

     

    What to do ? Please help @Misbah 

     

    Regards,

    Ankita

  • @ankitaga2000  Can you DM me here. I will try and help. 

  • @Misbah  I changed the time range and increased number of periods to 2 . Then i got the year 2020 in DAT03 historic volumes. After that my DEM03  Demand Forecast module gets the values for year 2020 and not for 2021. 

    ankitaga2000_0-1616416237201.pngankitaga2000_1-1616416252116.pngankitaga2000_2-1616416271003.png

     

     

    Please check

     

    Regards,

    Ankita

  • @ankitaga2000 

     

     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. @Misbah 

    ankitaga2000_0-1616416802082.png

     

    ankitaga2000_1-1616416802029.png

     

    ankitaga2000_2-1616416802276.png

     

     

     

    Please check

     

    Regards,

    Ankita

  • @ankitaga2000 

     

    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.

  • ankitaga2000_0-1616418456372.png

    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 ? @Misbah 

    Also if I go back and look at the activity in Sprint 2

    ankitaga2000_0-1616418869078.png

    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)

     

     

  • @ankitaga2000 

     

    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 @Misbah 

  • @ankitaga2000 

     

    Glad that it worked. Please close this query (along-with other queries) by marking it as solution accepted