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

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…
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…