Error: Dimension of mapping used for lookup doesn't match any dimension of the result

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

Screenshot_2020-11-02_at_14_89516.png

Accepted answers

JoanneM

@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. 🙂

All comments

einas.ibrahim

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 😊

https://community.anaplan.com/t5/Academy-Training/Altering-Line-Item-Formula-with-lookup/m-p/88856#M2524

If you still have questions please let me know.

Good Luck

JoanneM

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:

My target module REP04 has region and role as two dimensions.
I've referenced a different source this time the EMP01 which uses G2 Country and Department as dimensions, it also has medical costs data.
I've also had another module EP03 Employee Drivers by Role which is dimensioned by Department and Role, as part of the example data was imported via csv file.
So technically what I'm trying to do is to join EMP01 with EP03 on department, based on the result set to aggregate them into region vs. role so to populate my target module REP04.

Not sure whether I'm still on the right track?

Cheers

Joanne

JoanneM

@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. 🙂

MohammedHAJJAM

Hello i'm stuck in the same level would u like to share the Formula

Thanks in advance

Shashank123

Same for me, I have split it as well by two dimension but still shows the same error.

Thanks very much in advance

Quick Links

Can you help?

Unanswered questions

How have you from-scratch built lot-level, geo-based Inventory Consumption?
We’re working on modeling inventory consumption at the lot level, accounting for shelf life considerations, since we need visibility into which lots may not consume—both for risk reporting and E&O analysis. Each item may have customers with different shelf life requirements. For example, item A may need 270 days for some…
How to bring Row data into Columns?
Hi, Can you help me, how can we get row data into columns using Unique ID? Per attached below first snapshot, I want to bring rountingOrder 4, RecipientName, Sent and Completed dates in 1 row as show in sanpshot 2. Do I need to create Hierarchy list and Map?
How to Design Simulation Planning in Anaplan with Multi-Level User Input and Step-by-Step Logging?
Hi Anaplan Community, I'm working on a simulation planning model where users need the flexibility to input pricing adjustments at any level of the product hierarchy, and I’d love your guidance on best practices. 📌 Scenario Overview: We have a 4-level product hierarchy: Brand Category Sub Category SKU (lowest level) The…