How to link a property/line item on modules with different dimension

Options
Ana22
Ana22 Member, ALL USERS, Partner, Certified Model Builder Posts: 5 Contributor
in Planning & Modeling

Hi,

 

I need to get data from a line item from one module with a different dimension with my target module, I cannot do a lookup because the 2 dimensions are not totally related. See details below ;

 

I need to get the Position value from the source to the target, as you can see in the target module, not all Position list is mapped to an Employee so I cannot use a lookup, only the Position Line item/property is the same for both modules.

 

Ana22_0-1657537511459.png

Ana22_1-1657537532340.png

 

Thanks,
Ana

 

Tagged:

Comments

  • Ana22
    Ana22 Member, ALL USERS, Partner, Certified Model Builder Posts: 5 Contributor
    Hi, Yes that is correct.

    source - employee list
    target - position list,

    mapping of employee to position list is not 1:1 so I cannot do a lookup, sometimes, employee may be blank for a position list as seen in the example.

    Thanks,
    Ana
  • Ana22
    Ana22 Member, ALL USERS, Partner, Certified Model Builder Posts: 5 Contributor

    Hi, Thanks for this. but sorry, my mistake it was the other way around, should be this ;

     

    Ana22_0-1657587745944.png

     

  • Ana22
    Ana22 Member, ALL USERS, Partner, Certified Model Builder Posts: 5 Contributor

    Hi,

     

    The Position from the source is not the position code of the list, so I can't do a lookup. It's just a text same for both source and target.

     

    Thanks,

    Ana

Categories