Level 2 Sprint 2 DEM03 and DAT03

Hi Team,

When reviewing my latest workings and forecast per DEM03 and referencing this against the example for the baseline forecast DEM03 in sprint 2, I couldn't help but notice that my figures are different for the future periods commencing in Week 1 FY21. I'm not sure whether this is related to an error in DAT03.

Please see attached my formulae and extracts from my model, may I confirm why my figures are significantly higher than the ones set out in the example in the learning center please?

Thank you and regards

Matthias

Historic_Forecast_Example_111586.png

Formula_DEM03_111586.png

Historic_Volumes_DAT03_111586.png

Accepted answers

All comments

anand.shekhawat

Hi @mstanisic ,

Everything seems to be correct in the screenshots. Kindly share the your numbers as well for the future periods commencing from Week 1 FY21 where you are having the difference

~Anand

mstanisic

Hi Anand,

Thank you very much for the quick response, please see attached.

Week 5 FY20 is 69.94 vs. 59.47 in the example. I appreciate your continued support!

Thank you,

Matthias

Formula_DEM03_111597.png

anand.shekhawat

Hi @mstanisic ,

Kindly check the 'DAT03 Historic Volumes' Week 5 FY20 Data for 'Offset Volumes for 1st Forecast year'. This is the only value that you are pulling here. And this value comes from the data hub, while loading the historic volumes. If the values match in the data hub and the historic volumes file, then need not worry. Carry on with the model build, you are going correct.

I hope this helps

~Anand

mstanisic

Hello Anand,

Thank you for your feedback, I enclose an extract of the data that was uploaded and I can confirm that this aligns with the data in DEM03.

Kind regards,

Matthias

Upload_Historic_+_Volumes_111623.png

anand.shekhawat

Hi @mstanisic ,

Everything seems correct. You are on a right track.

~Anand

mstanisic

Thank you Anand for your continued support, I really appreciate it!

Best,

Matthias

Quick Links

Can you help?

Unanswered questions

Batch Script
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…