Sprint 3 Dat03 Historic Volumes

ankitaga2000
ankitaga2000
in Academy Discussions

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

  • Misbah
    Misbah

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

  • ankitaga2000
    ankitaga2000

    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

  • Misbah
    Misbah

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

  • ankitaga2000
    ankitaga2000

    @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

  • Misbah
    Misbah

    @ankitaga2000 

     

     If you had used Time Range in the module then it makes perfect sense.

  • ankitaga2000
    ankitaga2000

    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

  • Misbah
    Misbah

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

    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)

     

     

  • Misbah
    Misbah

    @ankitaga2000 

     

    Simple error, instead of -52 use 52 with LAG function. You should be able to see the numbers in FY 21 as well

  • ankitaga2000
    ankitaga2000

    Hurray got it fixed. So happy.Thanks a lot @Misbah 

  • Misbah
    Misbah

    @ankitaga2000 

     

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

Categories