Thursday, March 8, 2012

Assigning default aggregate function to calculated member

Is there any way to assign a default aggregate function (e.g. SUM) to a calculated member just like we can do this with a regular measure?

What I need to do is assign a custom calculation in my calculated member at the lowest grain (e.g. scoped at Date.Members and Customer.Members). Everything above this should be summed by default, e.g. Sales Territory.

Unfortunatelly, it is not possible to assign aggregation function to calculated members. If you need to aggregate them - you will have to do it manually with MDX.

The workaround is to use regular dimension members without data instead of calculated members, and assign MDX expressions to them.

|||

Hi, Mosha

Assuming the workaround, Is there difference in performance between a calculated member and a regular measure?

No comments:

Post a Comment