How do I disable 'Grand Total' in SSAS cube? 1

[pjohns]

Is there a way to disable 'Grand Total' for my SQL Server 2005 Analysis Services cube, so that it won't show up in the BI Dev Studio cube browser during design time or any reports built off the cube UDM after deployment?

You'd think this would be easy, but I'm not finding any way to do this or documentation on how to do this.

Thanks.

 

[MDXer]

This functionality is part of the cube browser and not the cube. TO remove the Grand Total Lines you RIght Click on the Dimension in the CrossTab and then unselect "Sub Totals"

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck