Hi gurus,
When building the reporting module 'REP04'(the target) I've tried to reference 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 'SYS08' 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.
Thanks
Joanne
Solved! Go to Solution.
Hello @JoanneM
You are on the right track.
Check this post, it might help you understand the root issue and arrive at the solution yourself 😊
If you still have questions please let me know.
Good Luck
Hi Einas,
Many thanks for your swift reply, I saw the quoted post and it was helpful.
I've given it another shot but this time it throws an error: Format of mapping used for lookup doesn't match any dimension of the source.
This is the thread of my thoughts:
Not sure whether I'm still on the right track?
Cheers
Joanne
@einas.ibrahim No worries, I figured it out I've got EMP02 calculated at good granular level so I just need to sum them up together by two dimensions in my target module.
Problem is solved. 🙂