disable grand totals for calculated measure.

I have measure in cube. Grand total for that measure need not be calculated & displayed..should be disabled.

How can i do this.

Can any one please tell me

Thanks in adv

Not sure what you mean by 'disabled', but you can always do something like that:

CREATE MyCalcMeasure = <expr>;

(MyCalcMeasure, Root()) = "DISABLED";

HTH,

Mosha (http://www.mosha.com/msolap)