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

Identifying Line Items Used as Filters or in Actions
I have always difficulty identifying line items that are NOT referenced by any other line items/modules but used in actions or dashboard filters. During model cleanup, we often encounter line items that appear unreferenced but may still be actively used as filters in dashboards or within actions. These usages are not…
Set up Anaplan Workflow Approval process at higher level
I need to create an Anaplan workflow where a task is completed at the subregion level, but the approval happens at the higher region level. The current Anaplan workflow functionality seems to require that the approval task is on the same page and at the same hierarchical level as the completed task. My specific question…
Need Help: Import Updates Only Specific Combinations Without Erasing Others
Hi Anaplan Community, I'm facing an issue while importing data (text details) into a module that has two dimensions: "Unique Line ID" and "Organization x Site". The source file is based on a numbered list. It includes text-formatted columns (line items) that contain the names of the "Unique Line ID" and "Organization x…