identify unused aggregations
SQL server has a dynamic management view called sys.dmdbindexusagestats which can tell you whether each index is being used.
SSAS should have the same type management view for its aggs and indexes and attributes... if you've had a cube in production for a few months and a handful of aggs haven't ever been used, they should be removed... this would be an easy way to tell. This is sort of the flip side of Query Based Optimization.
Upvotes: 1<=-=Oct 15 2007 12:34PM=-=>
There’s a feature in BIDS Helper that will help until something gets added to SSAS itself:
Unfortunately, this feature will not be added for SQL Server 2008, but we are considering for the next major release.
Thanks again for recommending this.
The Analysis Services Team