Sprint 3 Dat03 Historic Volumes

ankitaga2000
Frequent Contributor

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

1 ACCEPTED SOLUTION

Accepted Solutions
Misbah
Moderator

Re: Sprint 3 Dat03 Historic Volumes

@ankitaga2000 

 

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

View solution in original post

11 REPLIES 11
Misbah
Moderator

Re: Sprint 3 Dat03 Historic Volumes

@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
Frequent Contributor

Re: Sprint 3 Dat03 Historic Volumes

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
Moderator

Re: Sprint 3 Dat03 Historic Volumes

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

ankitaga2000
Frequent Contributor

Re: Sprint 3 Dat03 Historic Volumes

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

Re: Sprint 3 Dat03 Historic Volumes

@ankitaga2000 

 

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

ankitaga2000
Frequent Contributor

Re: Sprint 3 Dat03 Historic Volumes

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
Moderator

Re: Sprint 3 Dat03 Historic Volumes

@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
Frequent Contributor

Re: Sprint 3 Dat03 Historic Volumes

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
Moderator

Re: Sprint 3 Dat03 Historic Volumes

@ankitaga2000 

 

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