Report Portal

What hierarchies are actually being used in my cube?

Working out how to monitor Analysis Services usage is something I've spent a fair bit of time doing over the last few months; I'll get around to writing up my SQLBits presentation here soon, I promise, but in the meantime here's a quick blog entry on a related topic: how can you work out which dimension hierarchies your users are actually using in their queries? It's useful to know this for a number of reasons, for example if you're thinking of changing the AggregationUsage, AttributeHierarchyEnabled or AttributeHierarchyOptimizedState properties. Or if you're just plain curious.

 

Read more...

Tags: dmv

 

2007-2015 VidasSoft Systems Inc.