Formula error - dimension issue

Hi,

Can someone assist with a formula error I'm receiving?

I currently have 3 modules (see attached), and in the third module, I'm trying to calculate the number of meetings by entity and product. The error message I receive is: Dimension of mapping used for aggregation doesn't match any dimension of the source.

My formula is: 'C_Meetings by Entity'.Total Meetings[SUM: 'C_Meetings by Entity'.Product]

Can someone please direct me to where I'm going wrong?

Thanks in advance

Anaplan_-_error_83396.PNG

Accepted answers

All comments

nathan_rudman

You are summing by product which seems un-necessary as you have products in all source modules.

However if module 1 is the source, you don't have entity here so you'd need to SUM of an entity property (individual can be mapped to entity maybe ?)

Akhtar.shahbaz

Hi @CommunityMember113484

I am not sure about your proper use case & calculation, I have tried to replicate your scenario

as you already mentioned about the modules on top of it i have created one mapping module & one to find the meeting count.

Hope this helps!

Thanks

Akhtar

CommunityMember113484

Ah okay I see. So in my Module 1 now, I have both meeting ID, individual, product and entity.

In module 3 which attempts to sum total meetings product and entity, I'm still getting the same error?

michael.chefer

You need to bring the dimension of "Meeting" into module 3. In module 3 try creating a line item that is dimensioned by "Meeting". Then in your formula SUM on that new line item.

CommunityMember113484

Hi, I think i need a bit more guidance!

So my source module is:

My calculation module is below:

And this is where I'm struggling with summing the meetings by legal entity and products!

Thanks in advance,

nathan_rudman

you need to sum on the meeting mapping of your source module (and product, I think you should add that dimension to your LI item so it is the same as your module)

Quick Links

Can you help?

Unanswered questions

Create a Filter to show all the elements of that level based on selection in hierarchy
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
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…