February 3, 2010 at 2:53 pm
Is it possible to determine the usage frequency of the dimension attributes? I am trying to determine which attributes are never used or hardly used.
Thank you for your help.
February 23, 2010 at 9:08 pm
I would also be interested in tracking ALL usage of a cube. Is there a way to do this?
February 24, 2010 at 5:42 am
You can use SQL Server Profiler to monitor all the queries against your cube.
With the right options specified, you can filter out most of the events that you don't need.
But, analyzing all the queries and see wich attributes (or other cube items) are affected is quite a tedious task.
Here you can find a video of Chris Webb explaining the SQL Server Profiler in order to design aggregations in your cube:
http://www.microsoft.com/belux/MSDN/nl/chopsticks/default.aspx?id=1499
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply