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

JoeyP
JoeyP
in Modeling

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???

image.png
image.png
image.png

Answers

  • ManujChaturvedi
    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
    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
    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.

    image.png

  • JoeyP
    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
    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
    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,

    image.png
    image.png

  • rob_marshall
    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

    image.png

Categories