Level 2 Sprint 2 - Can't get data into DEM03 module

[jessicaereed]

Hello,

I am stuck in Sprint 2 of the Level 2 Model Building course. I have gone through Sprint 2 several times I redid Sprint 1 just to make sure my imports were good. I can't get anymore data in DEM03 other than growth rate. Can someone please help!

[Misbah]

@jessicaereed

Go to DAT03 module and see if you have data populated in that module

Misbah

Miz Logix

[jessicaereed]

No I don't. I have been changing the time scale and redoing inputs and I can't get anything to come into DAT03.

[Misbah]

@jessicaereed

Change the dimensionality of the module from Year to week as you have in line items. You shouldn't be having any subsidiary views.

Change it and then re upload the data.

Hope that helps

Misbah

Miz Logix

[jessicaereed]

I did that and I got the volume data to come in but I can't get the offset values to come in.

[Misbah]

@jessicaereed

You will have to check the data in FY20 when you are using Offset with -52.

So Week1 FY19 data will be pushed to Week 1 FY20. Check that and see if it is working or not.

If it is not populated then go to SYS01 Time settings by Week module and see if 1st Forecast Year line item is checked or not. It has to be checked for FY20

Misbah

Miz Logix

[jessicaereed]

It's not checked but I have no idea what to do to make sure it's checked.

[VaibhavS]

Check if your model calendar and time ranges are set correctly to point FY 20 as current year. See the screenshots attached for reference.

Hope this helps.