Level 1 Model: Dimension of mapping used for lookup doesn't match any dimension of the result

Options
JoanneM
JoanneM Member, ALL USERS, Employee Posts: 5 Occasional Contributor

Hi gurus, 

 

When building the reporting module 'REP04'(the target)I'm trying to reference to an existing module 'EMP03' (the source) for the calculated medical costs. REP04 has two dimensions 'Region' and 'Role' whilst EMP03 has 'Department' and 'Role', hence I tried the mapping module 'SYS09' to fill the gap. Thought it's ok but still run into 'Dimension of mapping used for lookup doesn't match any dimension of the result', any help is much appreciated. 

JoanneM_0-1604326009387.png

 

Comments

  • JoanneM
    JoanneM Member, ALL USERS, Employee Posts: 5 Occasional Contributor
    Hi Noemi,
    Many thanks for your swift reply, it does help and I fully agree with you the dimensionality of those two modules do not match and it's best to get the original calculation individually referenced. However this is part of level 1 exam and data is entered in these two modules so I'm trying to join them via the mapping module 'SYS08'.
    Cheers
    Joanne