Level 2 2.3.10 Growth Rate Formula Error

VHoward

Hello All-

I am getting an error when applying the growth percentage formula

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

Here is the formula I am using:

'SYS01 Time Settings By Week'.'1st Forecast Year?'

THEN

'DEM02 Volume Growth Rates by Week'.Growth % [LOOKUP: 'SYS08 SKU Details'.Product Family]

ELSE

I have sum set to none on the Growth % line item.

Any tips?

Comments

Sathya M

Hi @VHoward,

The below mentioned formula is correct. Kindly check the format of the SYS08 SKU Details. Product Family. It should be "P1 Product Family".

Thanks

Sathya

VHoward

Thank you Sathya. I must be fairly close, as I am no longer getting the error. Now I am just not getting any results.

Screen shots attached.

DEM_03_Results_147617.PNG

DEM_03_147617.PNG

Sathya M

Please check your Applies To in the "Growth %" Line Item. It must include P3 SKU and Accounts as dimension.

VHoward

Interesting...it will let me add Accounts in Applies To in the "Growth %" Line Item...but when adding P3 SKU I get the dimension error again.

VHoward

Any further suggestions. I have followed advice in posts and still do not have data. Attaching screen shots of related Modules. One curious thing is that the data view of SYS08 has product family as blank. Maybe that is a problem?

DEM01_147776.PNG

DEM02_147776.PNG

DEM03_147776.PNG

SYS08_Data_View_147776.PNG

SYS08_Design_View_147776.PNG

Sathya M

Please find below the screenshots of SYS08 SKU Details and DEM03 Demand Forecast modules.

The line items Growth % (DEM03) and Product Family (SYS08) dimensions are blank in the "Applies To". Kindly correct them and you can see the result (refer below screenshots)

Thanks

Sathya

ChrisAHeathcote

A LOOKUP formula acts as a bridge between two or more dimensions where the target and the mapping module share a common dimension. The bridge from the source module to the target is then completed via the line item in the mapping module which must be formatted as the missing dimension in the source.

In your case the source module must contain the product family dimension as the line item in the mapping module SYS08 is set to Product Family and the target module must contain SKU as a dimension as this is the dimension of the SYS08.

The error message indicates that one of this is not the case. Check that you are using the correct SYS module and referencing the correct line item to map from source to target.

ChrisAHeathcote

Your product family line item is a subsidiary view.
Go into the blueprint and change the applies to for this line item to match the module.

Quick Links

Recent release news

November 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our November 2025 official release notes. The information below offers supplemental information to that post. Intelligence Anaplan Forecaster: General enhancements Anaplan Forecaster now supports list subsets for the item ID list and custom time, list format…
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…