Level 2 - Conclusion - INV05 and DEM04 - Import with Subsidiary View

Highlighted
Contributor

Re: Level 2 - Conclusion - INV05 and DEM04 - Import with Subsidiary View

Hi -

 

I have pivoted, left the lowest levels for SKU and Location however and filtered as per your suggestion. However, i am not getting the same view as you. With New Your and Jan 20 selected, i still see a full list of all of the SKUs, and I should be seeing SKUs for NY only, correct? What could I be doing wrong?

thank you 

 

Demand Import.PNG

Highlighted
Contributor

Re: Level 2 - Conclusion - INV05 and DEM04 - Import with Subsidiary View

hi @sdavidko 

I would check your Demand formula. It looks like you have data in there that should be 0 for a lot of those SKUs. Hint, you might be missing a sum.

Highlighted
Contributor

Re: Level 2 - Conclusion - INV05 and DEM04 - Import with Subsidiary View

@smithevan18  thank you for your prompt reply. My Demand formula is just pulling Demand Final Forecast from DEM03. For some reason however, I cannot get the Location page selector to work so that it only gives me SKUs for the given location.

Highlighted
Contributor

Re: Level 2 - Conclusion - INV05 and DEM04 - Import with Subsidiary View

@smithevan18  I guess, I dont understand why are you pulling WEEK data (which is in DEM03) into MONTH (DEM04) of Jan 2020, why one week of final demand is populated and presented as Monthly demand?

Highlighted
Contributor

Re: Level 2 - Conclusion - INV05 and DEM04 - Import with Subsidiary View

Hi @sdavidko 

 

When you pull from a weekly timescale into a monthly timescale, if you have your summary methods turned on, Anaplan will automatically aggregate up to the monthly amount. So your monthly module (Dem 04) should be using the monthly data that is in your weekly module (DEM 03). I think you're potentially missing the sum on the locations dimension because that is the added dimension in your source module. Hope that helps!

Highlighted
Contributor

Re: Level 2 - Conclusion - INV05 and DEM04 - Import with Subsidiary View

Hi 

@smithevan18  in my Demand formula, I am pulling from DEM03 final forecast and summing by Locations details from account details. However, i am still not getting the numbers you had on your screen shot.