Level 2 Sprint 2 Module to Module Aligning Dimensions Mapping

Options
Joh04924
Joh04924 Member, ALL USERS, GroupMember, Community Member, Certified Model Builder Posts: 5 Occasional Contributor
in Planning & Modeling

In one of the Sprint 2 activities, we need to reference data from one Module to another. To do this you must align the dimensionality of the Source Module to the Target Module. However the List dimension in the Source Module is a Parent of the corresponding dimension in the Target Module, requiring us to use an intermediary (SYS) module to align the source to the target.

 

How would you do that?

 

I have tried multiple variation of LOOKUP, and LOOKUP & SELECT however I continue to receive error messages.

 

Tagged:

Comments

  • Joh04924
    Joh04924 Member, ALL USERS, GroupMember, Community Member, Certified Model Builder Posts: 5 Occasional Contributor

    @einas.ibrahim 

     

    Thank you for the response!

    What do I do if it is the reverse situation? I am having trouble mapping the formula to the intermediary module.

  • Aaron82
    Aaron82 Member, ALL USERS, GroupMember, Community Member, Certified Model Builder Posts: 5 Occasional Contributor

    Hi Joh04924 and others pursuing the L2 course,

     

    I would recommend looking at the system modules already available to you that align the parents for each hierarchy level. 

    Readily available are the Product Details and SKU Details modules which list the parents in their modules.  

     

    Create a new (intermediary - they make it sound more scary than it is) module that takes the growth rate line item by Product Family and write the lookup for SYS04 Product Details.Product Family. 

     

    Then in the Demand Forecast module, do the same but for SYS08 SKU Details.Product 

    The second one would look like so:

    'DEM02 Volume Growth Rates by Product'.Growth %[LOOKUP: 'SYS08 SKU Details'.Product]

     

    Cheers,

    Aaron

     

Categories