Level 2 Model Building Conclusion - DEM04 Demand Export Demand values

CamilleDeBo

Hi,

Could someone please help me with the following?

Solution DEM04 should be this:

My DEM04 Demand Export:

My values are way higher, Demand line item is not for each product SKU. How can I fix this?

My DEM04 blueprintview:

Baseline Forecast:

Thanks in advance!

Comments

Misbah

@CamilleDeBo

If you look at the dimensionality of DEM03 it is P3 SKU and Accounts where as in DEM04 it is P3 SKU and G3 Location, there is one dimension which is not matching. I would say think about how you aggregate the data from DEM03 to DEM04. You are missing SUM function in the formula.

X[SUM:Y], Here Y is the mapping between Accounts and G3 Locations.

Hope that helps

Misbah

Miz Logix

CamilleDeBo

Thank you!
I will try to solve it.
Kind regards,
Camille

ShirleyV

@Misbah

Hi,

I found the only list have relationship of Accounts and Location is SYS09.

I put the formula as below but it does not work. Any hint?

'DEM03 Demand Forecast'.Final Forecast[SUM: 'SYS09 Account Details'.Code]

Misbah

@ShirleyV

Try something from SKU details module where you see Distribution center as line item.

Thanks,

Misbah

Miz Logix

ShirleyV

@Misbah

I tried to use SYS08 with distribution center for Demand='DEM03 Demand Forecast'.Final Forecast[SUM: 'SYS08 SKU Details'.Distribution Center] but it returns total demand per SKU not by location.

JWags

I need help too on this matter,
I have been looking for the solution for more than 5 hours now and this is my last day of access to the platform. I need to get my certification before tomorrow.

nhatduytk012

Hi, you need refer to account detail location , not SKU detail location because DE03 is having account demension

TyroneW

Is this correct? Can someone please check?

'DEM03 Demand Forecast'.Final Forecast[SUM: 'SYS09 Account Details'.Location]

AjayM

Hi @TyroneW ,

That's correct to sum final forecast by G3 location, for each SKU.

While P3 SKU is common dimension between DEM03 and DEM04, SYS09 provides linkage between Accounts and Location.

Cheers!

TyroneW

Thank you @AjayM !

dpong8898

It should be 'DEM03 Demand Forecast'.Final Forecast[SUM: 'SYS09 Account Details'.Location] instead of Code

donaldleung

It is still not working for me too.

I'm using Demand = 'DEM03 Demand Forecast'.Final Forecast[SUM: 'SYS09 Account Details'.Location] too.

But it shows all zero. If I use Demand = 'DEM03 Demand Forecast'.Final Forecast[SUM: 'SYS08 SKU Details'.Distribution Center], I can only have the Total Demand aggregated.

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…