Dimension Mismatch

Hi,

Please see attachment for details.

Regards,

DImension_Mismatch_53234.docx

Tags

Modeling

Calculation Functions

Accepted answers

Hi,

do you know that you can put pictures in the post ? it would be easier for us !

When a target module references a source module and they don't have the same dimensions, you need to indicate to Anaplan how the target module can read from the source.

By default, Anaplan will try to sum, but that would not work if you don't have a top level on your dimension. Otherwise, you can use [LOOKUP:] to dynamically reference a specific element within the dimension, [SUM:] to sum values into a dimension following a property or [SELECT:] to select a specific element (to only use on the top level or an element that will NEVER change).

In your case, Anaplan can automatically sum the values of your rows, but you need to to indicate how to reference the Project and Dev Cost dimensions. You can do so using the formulas I explained above, depending on the logic you need.

I hope this helps.

I would also take a look at this post recently. There is a lot of good content explaining the differences and how to use SUM and LOOKUP

https://community.anaplan.com/t5/Anaplan-Platform-Discussions/Lookup-Sum-and-Textlist-Cheat-Sheet/m-p/53143#M8226

David

All comments

Hi,

do you know that you can put pictures in the post ? it would be easier for us !

When a target module references a source module and they don't have the same dimensions, you need to indicate to Anaplan how the target module can read from the source.

By default, Anaplan will try to sum, but that would not work if you don't have a top level on your dimension. Otherwise, you can use [LOOKUP:] to dynamically reference a specific element within the dimension, [SUM:] to sum values into a dimension following a property or [SELECT:] to select a specific element (to only use on the top level or an element that will NEVER change).

In your case, Anaplan can automatically sum the values of your rows, but you need to to indicate how to reference the Project and Dev Cost dimensions. You can do so using the formulas I explained above, depending on the logic you need.

I hope this helps.

I would also take a look at this post recently. There is a lot of good content explaining the differences and how to use SUM and LOOKUP

https://community.anaplan.com/t5/Anaplan-Platform-Discussions/Lookup-Sum-and-Textlist-Cheat-Sheet/m-p/53143#M8226

David

Quick Links

Can you help?

Unanswered questions

PlanIQ - Unexpected Forecast Drop After Removing Outlier Correction
I’m forecasting monthly demand with a focus on a rolling 6-month horizon (out of an 18-month view), using PlanIQ in Anaplan. My forecast uses 7 models: ARIMA, Prophet, ETS, MVLR, Ensemble, DeepAR, and CNN-QR. Each month, I perform 6-month backtesting and calculate MAPE for each model, then select the best-fit forecast…
How to Design Simulation Planning in Anaplan with Multi-Level User Input and Step-by-Step Logging?
Hi Anaplan Community, I'm working on a simulation planning model where users need the flexibility to input pricing adjustments at any level of the product hierarchy, and I’d love your guidance on best practices. 📌 Scenario Overview: We have a 4-level product hierarchy: Brand Category Sub Category SKU (lowest level) The…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…