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

VenturaLand

Hi Noelle,
Where can I find the recorded sessions?
Thank you,
Kim

GONI

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

noelle_murphy

Hi Kim,

Q/A sessions are not recorded.

Noelle

ec35

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.

noelle_murphy

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

ec35

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.

GONI

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.

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

noelle_murphy

Thanks.

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

Noelle

Quick Links

Recent release news

October 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our October 2025 official release notes. The information below offers supplemental information to that post. Planning experience Combined Grids This new capability gives page builders the ability to combine multiple modules into a single, unified grid on a UX…
Recording now available! October 29 platform release event
If you missed our October 29, 2025 platform release event, the recording is now available! In this webinar, we highlighted the most recent feature releases and how to take advantage of these in your environment. Our expert-led session demonstrated new features and innovations, provided a technical deep-dive and “how-to”,…