Level 2 Conclusion DEM04 Demand Export

Highlighted
New Contributor

Level 2 Conclusion DEM04 Demand Export

@Misbah 

Could you tell me what I am doing wrong in this formula.
Demand = 'DEM03 Demand Forecast'.Final Forecast[LOOKUP: 'SYS08 SKU Details'.Product]

10 REPLIES 10
Highlighted
Master Anaplanner/Community Boss

Re: Level 2 Conclusion DEM04 Demand Export

@Jemsheed 

 

Check the dimensionality of your source module and target module and decide if you need LOOKUP or SUM.

Highlighted
Occasional Contributor

Re: Level 2 Conclusion DEM04 Demand Export

Hi @Misbah',

 

I am also stuck on this question. I am struggling to understand why my mappings are not correct if the source module has the following dimentions: SKU, Accounts.

This is my formula: 'DEM03 Demand Forecast'.Final Forecast[SUM:'SYS08 SKU Details'.Code,SUM:'SYS09 Account Details'.Location]

 

Could you please help me understand where am I going wrong? 

 

Thank you!

Highlighted
Valued Contributor

Re: Level 2 Conclusion DEM04 Demand Export

@Yudashkin001 

 

The Target module: is DEM04 --- Dimension: G3 Location, P3 SKU, Time (Months)

The Source module: DEM03 --------Dimension: P3 SKU, Accounts, Time (Weeks)

 

image.png

 

For LOOKUP to work,

  1. You have to determine the module where your Source data resides (DEM03) and then look at the dimensions of that source module (P3 SKU, Accounts).
  2. In order to retrieve a single data cell (single intersection), you have to provide all the Source module dimensions in your LOOKUP formula; Unless the Target includes that dimension.
    In this case, P3 SKU is a common dimension so we don't have to worry about it.

That leaves up with Accounts, right?   

Do we care about Demand broken down by Accounts? No, we are looking for the demand for P3 SKU in all Accounts. If you don't provide a LOOKUP with Accounts, the formula will return the data (demand) for all items in the missing dimensions i.e. Accounts (Top Level- All Accounts) because it doesn't know which Account data you are looking for; and that's what we need.

 

That leaves us with nothing to provide in the LOOKUP formula. which means we don't need a LOOKUP. A direct reference will provide you with the data you are looking for. 

 

As to the reason SUM is not the right formula here, that is because we are looking for Demand by P3 SKU and the Source has the demand by P3 SKU. so there is nothing to SUM.

 

I really care about explaining how to use LOOKUP and how to think about obtaining the answer more than the correct answer. 

Let me know if I need to explain any point further or even in a different way,

 

Good Luck

 

Einas
"Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"
Highlighted
Occasional Contributor

Re: Level 2 Conclusion DEM04 Demand Export

@einas.ibrahim , you really helped me out! Thank you so much for such an elaborate explanation!

Highlighted
Valued Contributor

Re: Level 2 Conclusion DEM04 Demand Export

Hi @Yudashkin001 

I'm glad it was helpful.
"Elaborate Explanations" is my brand, doesn't always work in my favor though😀
If you have further questions while you are going through the training, post it, and mention me.

Good Luck

Einas
"Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"
Highlighted
New Contributor

Re: Level 2 Conclusion DEM04 Demand Export

Your explanation made so much more sense to me than the training itself.  Thank you.

Highlighted
Valued Contributor

Re: Level 2 Conclusion DEM04 Demand Export

Hello @CommunityMember130913 

 

Thank you and shhhhhh, "they" will hear you and get mad at me 😂

Seriously, I'm happy I was able to help, if you have other questions please let me know.

Einas
"Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"
Highlighted
Contributor

Re: Level 2 Conclusion DEM04 Demand Export

Hi @einas.ibrahim 

 

I Use direct reference for my DEM04 demand formula referencing to DEM03 and did not use any of SUM OR LOOKUP function as suggested by you. But this is regarding the importing of file while doing to DAT02 in the FPA model, I am unable to get my SKU & LOCATION code as can be seen in detail in the below link, where I seek guidance but did not receive any reply, so seeking out to you.

 

https://community.anaplan.com/t5/Academy-Training/Level-2-Conclusion-INV05-and-DEM04-Import-with-Sub...

 

Can you help me why my solution didn't match with smithevan18  as he was suggesting that we are missing on SUM formula for our location line item?

Highlighted
Valued Contributor

Re: Level 2 Conclusion DEM04 Demand Export

Hey @kunal_311 

Happy to assist. 
Can you please separate this issue from other issues or posts. It will be clearer for me to understand and also make it easier for others to clearly find solutions to their issue in the future.

There are at least 2 different posts with different issues. I'll appreciate it if you create a new post simply explaining the issue you are facing.

We can add a link to that post here after you create it if you think it'll help people find the answers they are looking for.

 

Thank you

Einas
"Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"