Level 1 Model Building : Add Formulas to REV05 Price Growth Rates Staging Module

I have been creating the model exactly as per the instructions and training material. However, I am getting the following error in lesson 9 adding formulas to REV05 Price Growth Rates Staging Module.

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

FORMULA : 'REV04 Price Growth Rates'.Unit Price %[LOOKUP: 'SYS04 Location Details'.Country, LOOKUP: 'SYS06 Product Details'.Product Family]

Comments

Bahman.khalaj@anca.ocm

Check if in your module there is a space between "Price" and "%" , if not, add.

vaibhavthakkar01

Thank You.. There was some other issue with the Mapping which was throwing the error.

KARASAGE

what was the error, I am having the same issues

vaibhavthakkar01

Hi,

I don't remember the what the error was, its been months now since I was stuck on that. However, I can help you with the formulas that I have used, you can check those with your formula and rectify the error.

Unit Price % - 'REV04 Price Growth Rates'.Unit Price %[LOOKUP: 'SYS04 Location Details'.Country, LOOKUP: 'SYS06 Product Details'.Product Family]

Unit Cost 5 - 'REV04 Price Growth Rates'.Unit Cost %[LOOKUP: 'SYS04 Location Details'.Country, LOOKUP: 'SYS06 Product Details'.Product Family]

Regards,

Vaibhav

neerajahuja77

I am also getting the same Dimension is used for Lookup doesn't match any dimension of the result. Can someone help

Quick Links

Recent release news

September 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our September 2025 official release notes. The information below offers supplemental information to that post. Planning experience Improved Keyboard navigation across cards Across Boards, Insights, and Worksheets, tab navigation through toolbars in cards and…
Register for our October 29 platform release webinar!
Anaplan's next quarterly platform release webinar will be held October 29, 2025 at 8 a.m. Pacific Time. During this session, we will explore the latest features so you can optimize your Anaplan experience. Our expert-led session will equip you with a practical guide and live demonstrations to help you get the most out of…