Level 2 Conclusion DEM04 Demand Export

Options
Jemsheed
Jemsheed Member, ALL USERS, Community Member, Certified Model Builder Posts: 5 New Contributor
in Planning & Modeling

@Misbah 

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

Tagged:

Comments

  • Yudashkin001
    Yudashkin001 Member, ALL USERS, Community Member, Certified Model Builder Posts: 2 Occasional Contributor

    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!

  • Yudashkin001
    Yudashkin001 Member, ALL USERS, Community Member, Certified Model Builder Posts: 2 Occasional Contributor

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

  • CommunityMember130913
    CommunityMember130913 Member, ALL USERS Posts: 1 New Contributor

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

  • asage
    asage Member, ALL USERS Posts: 2 New Contributor

    @einas.ibrahim 

    Care to explain a little more? Here is my issue:

     

    I have a list that provides roles (name and code). I have data that provides employee and their role. In order to do a LOOKUP, I need to have my dimension as a list. Under the module that has the data, do I need an additional Line Item that associates the Role list to the Employee data?

     

    Thank you

  • ConRourke
    ConRourke Member, ALL USERS, Certified Model Builder Posts: 1 New Contributor

    @einas.ibrahim 

     

    Thank you for such a great explanation. I was using a LOOKUP and you made this issue very easy to understand. 

     

    Cheers, 

    Connor 

  • cbevishnu1
    cbevishnu1 Member, ALL USERS Posts: 3 Occasional Contributor
    This is the best explanation i have come across about sum and lookup. Thank you
  • Akumar94an
    Akumar94an Member, ALL USERS, Community Member Posts: 5 Occasional Contributor

    @einas.ibrahim thank you for the elaborate explanation! There were quite a few possibilities I was thinking of while trying to understand whether to use SUM or LOOKUP. However, the solution to the formula is pretty straightforward. Thanks, to your explanaiton, all those possibilities were covered up.

Categories