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

Hello,

I can't understand why I keep getting this error. I am trying to bring in Keeper 1 from the source module that is dimensioned by player, but the line item is an "owner" list line item. My target module is dimensioned by Owner with the line item as a "Player" list line item. See Screen shots below, what am I missing???

Accepted answers

All comments

ManujChaturvedi

Your source module has the Keeper 1 line item dimensioned by player while your target module is dimensioned by owner. This mismatch is likely causing the error as you cannot map a player - dimensioned line item into a module that uses the owner dimension unless there is a direct and transparent relationship between the two.

Try creating a mapping module and then apply that lookup function of yours. Hope this clears a little bit of your doubt.

Thank you.

Rajat26

Hi @JoeyP,

Looks like the source dimension and the mapping dimension is same in your case, hence you should try using SUM family function in this case TEXTLIST, convert the list formatted line items into text and use TEXTLIST then u can convert them back if u want it in the list format.

Thank you.

rob_marshall

@Rajat26

TextList() isn't the answer nor is converting it to Text.

@JoeyP

Look at your formula again, you have INP 110 Players Input on both sides of the logic.

JoeyP

@rob_marshall Yes, but the lookup line item in INP 110 "owner of keeper / auction" is nested by Owners, not players, so I am confused as to why this won't work. i have a direct relationship between Owner & Player.

rob_marshall

@JoeyP

Since Owner of Keeper / Auction is dimensionalized by Players and your Target is dimensionalized by Owners, it has no way of making the connection. Remember, the lookup has to be looking up a member on the "outside" of the house (a member either in the rows, columns, or page axis) while the SUM can do it on a line item/transactional data.

Rajat26

@rob_marshall

I had a similar problem which I solved using Textlist(), I know it's not recommended to use it, but it worked for me,

rob_marshall

@Rajat26

TextList() is one of the worst performing functions that we have. The reason TextList() works is because it is "summing" the transactional data. A better way of doing what you did is to use FirstNonBlank or LastNonBlank instead of converting it to Text and then using TextList().

Link to TextList in the Planual

Quick Links

Can you help?

Unanswered questions

Sorting General List
Hi, I wonder if there's a way I can sort my general list alphabetically. The list is used as a drop down menu in a line item module and I want the drop down menu to be easy to navigate. I've already tried the Order List action. I already have a module with a text-formatted line item based on that list. But when I try to…
Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…