Dear Friends,

I have given dimension level security, for one of the Dimension in my Cube. Problem is if i have "All Level" enabled for the users, they see wrong Grand Total and if i remove "All Level" they don't see Grand Totals.

I would like to given Grand Total, rather then doing "All Level" can you tell me how this can be achieved.

Regards,

Kaushal