Format of mapping used for lookup doesn't match any dimension of the source

EmmaPF
Occasional Contributor

Format of mapping used for lookup doesn't match any dimension of the source

Hi all,

I've looked through several of the queries/answers on this topic and still can't work out what I am doing wrong...

I am trying to provide a summary of employee expenses by region and role in REP04;

EmmaPF_0-1638545645039.png

I am trying to use EMP02 as my source as this has employee expenses by employee and department. As there is no direct link I was using SYS08 as a lookup link referencing the Employee role and Region (the link being through the common employee details). I get the following;

EmmaPF_1-1638545892174.png

I'm clearly missing something in the logic - no idea what though...

Thanks in advance!

Emma

 

1 ACCEPTED SOLUTION

Accepted Solutions
EmmaPF
Occasional Contributor

Re: Format of mapping used for lookup doesn't match any dimension of the source

think I have figured it out - it's not a lookup it's a sum based on certain criteria...

 

View solution in original post

1 REPLY 1
EmmaPF
Occasional Contributor

Re: Format of mapping used for lookup doesn't match any dimension of the source

think I have figured it out - it's not a lookup it's a sum based on certain criteria...