How can I map these two dimension ?

Options
Sumon16
Sumon16 Member, ALL USERS, Community Member Posts: 3 Occasional Contributor
in Planning & Modeling

I am writing formula for growth percentage where time dimension in weeks, and having product family as a list i.e. Product SKU's. In source module I have product family AS a dimension, where product SKU is third level of product family hierarchy.

 

How can I map these two dimension ?

Tagged:

Comments

  • vivekdasgupta
    vivekdasgupta Member, ALL USERS, Certified Model Builder Posts: 3 New Contributor

    Hi Sumon,

     

    You can add one Line Item called Product in your target module. It will be a formula

    Formula -  PARENT(PARENT(ITEM(SKU)))

     

    Then you can write a formula for picking up the Growth % from the Source Module like below:

     

    'Product Family'.Growth%[LOOKUP: Product]

     

    Hope this is the mapping you were looking for.

     

    Regards,

    Vivek Das Gupta

Categories