nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Level 2 sprint 3 - INV01 inventory ordering Grid

Donna Marie

there is an error detected in the highlighted cell

please advice how to get this corrected

INV01_Inventory_Ordering_Dashboard_with_error_66135.pdf

Accepted answers

All comments

Panji

Hi @Donna Marie,

You just need to get data from DEM03 Demand Forecast and line item Final Forecast

Regard,

Panji

Donna Marie

I am already using this formula 'DEM03 Demand Forecast'.Final Forecast

the data seems fine for the entire row except for the cell highlighted

Panji

Hi,

I think you should check formula in 'DEM03 Demand Forecast' maybe you miss something in a some line item, or can you give a screenshoot modul DEM03 with formula so i can identify to corrected

Regard,

Panji

Donna Marie

please find attached screen shot of the formulas used in DEM03 Demand Forecast module

DEM03_Demand_Forecast_66141.pdf

Panji

HI,

Thankyou for file attached, i think you need check data in week 1 - week 4 have same amount like this

note: in week 2 candyate im overide to 62

if not the same you can check in DAT03 Historical, if not same too maybe you need re-upload file volumes to DAT03 Historical

Thanks

Donna Marie

yeah that cell is not showing the same number as the rest

shall I reload data historic volumes. csv into Data hub DAT 03 Historical

Donna Marie

the dat03 historical volumes are showing these for FY20

please see attached

should I reload the csv file into DAT03?

DAT03_Historical_Volume_66151.pdf

Panji

Hi,

Yes you need to re-import Historic Volumes into Data hub DAT03 Historic Volume and after that you need check data has been the same with excel or not, if same you can import from datahub to Level 2 model.

Regard,

Panji

No, because data historical only have FY19. you dont need import to FY20

Donna Marie

my forecast numbers are not the same still for cell highlighted in week2

please see attached screenshot

INV01_Inventory_ordering_error_still_cell__66159.pdf

Nivetha

Hi @Donna Marie

In DEM03 Demand Forecast, make sure to check for all the Accounts and P3SKU dimensions, the Final Forecast line item is not overridden, by override? and Override Forecast line item in Week2 FY20.

Thanks,

Nivetha K

Quick Links

Can you help?

Unanswered questions

How Can I Recreate Anaplan’s “Reporting Tips & Tricks” Showcase Model for Learning Purposes?
Anaplan Modelers: Has Anyone Recreated a Showcase Model for Learning Purposes? One of the most valuable learning resources I've come across is Anaplan's Modeling Showcase. It features sophisticated, real-world model examples that offer an incredible opportunity to learn how experienced model builders structure their…
Introducing Anaplan Toolkit: side panel for model details, exports and model lock tracking
Hi everyone 👋 If you build or maintain Anaplan models, you've probably hit the same walls I kept hitting. Some basic questions about a model's structure have no single screen to answer them. You end up clicking through modules and pages one by one, or writing API scripts just to get a list. These were the gaps that…
How to handle an Entity Structure change effective from January 2026 in Anaplan Consolidation & Repo
Hi Everyone, We have a requirement in Anaplan Consolidation & Reporting (Fluence) where the Entity Structure needs to change effective January 2026. The key requirement is that the existing entity structure should continue to be applicable for all reporting and consolidation periods through December 2025, while the new…