Sprint 3 Dat03 Historic Volumes

ankitaga2000

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

Comments

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

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

Regards,

Ankita

Misbah

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

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.

Please check

Regards,

Ankita

Misbah

@ankitaga2000

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

ankitaga2000

But can you please tell why DEM03 Demand Forecast module gets the values for year 2020 and not for 2021. @Misbah

Please check

Regards,

Ankita

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

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

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

@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

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

Misbah

@ankitaga2000

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

Quick Links

Recent release news

June 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our June 2025 official release notes. The information below offers supplemental information to that post. Security and administration New 'Application Owner' security role Tenant administrations can assign the Application Owner role to users in their tenant.…
Register for our July 30 platform release webinar!
Anaplan's next quarterly platform release webinar will be held July 30, 2025 at 8 a.m. Pacific Time. During this session, we will explore the latest features so you can optimize your Anaplan experience. Our expert-led session will equip you with a practical guide and live demonstrations to help you get the most out of new…