define measure aggregate at run time

Am using OLAP a开发者_运维百科nd i want to make measure functions e.g(count,max,..) to be selected by the user (to be as a filter).

Is there a way to choose measure aggregate function of a cube at run time ?

Thanks in Advance

Got a bit more time, I don't think it's possible to switch the aggregation type of a measure in the MDX servers I know. Take into account some improvements (speed and memory) may rely on the kind of aggregation you're using.

Two possible solutions :

• Create calculated members to calculate count,max -> Aggregate(...) issue here is a drop in performance.

• Have already all measures created (amount-max,amount-min) and use a selector or utility dimension to switch it. Utility dimension are not standard dimension as they don't hold values but transformation. You can find a bit of inspiration here.