Activity 9.2.5 Activity: Error Message with Formula

In today's Q/A session, we had the question about a formula not working for the REV05 Price Growth formulas. 

 

After further model review, we noticed that the Product Family, Product Details and Location Details modules had the Time Dimension. After removing the Time Dimension the formula was accepted successfully.

 

Noelle

 

Comments

  • Hi Noelle,
    Where can I find the recorded sessions?
    Thank you,
    Kim
  • I think Q/A sessions are not recorded, only special topic sessions are recorded. If still Q/A session are recorded would like to watch.

     

    Regards, 

    Basavaraj 

  • Hi Kim, 

     

    Q/A sessions are not recorded. 

     

    Noelle

     

  • The error message I get is "Dimension of mapping used for lookup doesn't match any dimension of the result." None of the modules mentioned above have the time dimension. Not sure how to proceed.

  • Hi There, 

     

    I am not sure which part of your model you are referring to. Can you share more details, what you were working on and screen shots?

    Thx

  • I'm referring to Activity 9.2.5 where I'm trying to input the formulas.

    error message https://prnt.sc/vh1yp8

    REV05 https://prnt.sc/vh1ysv

     

    first formula reference (REV04) https://prnt.sc/vh1zqt

    SYS04 https://prnt.sc/vh202k

    SYS06 https://prnt.sc/vh20c5

     

    I'm not sure which dimension isn't matching to what. Thankfully this formula hasn't been super important to anything else and I've been able to complete lessons after this.

  • Hi, 

    The error message(Dimension of mapping.....) is because there is mismatch in formatting across your module. For example Country you define as text in one and number in another. So when writing lookup this will throw error. 

     

    And when I check the rest 3 scree captures, See highlighted. It clearly tells there is mismatch in formatting. 

    GONI_0-1605075943171.png

    So now I feel open all the system modules check the format of line items/dimensions. Let us know if still issue persists.

     

    Stay Safe,

    Basavaraj Goni

     

  • Thanks. 

     

    I cannot access your screen shots. Are you able to upload the images instead of links?

     

    Noelle