Tracking Dimension Attributes Usage

• aldynguyen

  SSC Enthusiast

  Points: 150

  More actions

  February 3, 2010 at 2:53 pm

  #144752

  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.

• checkai

  Hall of Fame

  Points: 3041

  More actions

  February 23, 2010 at 9:08 pm

  #1124051

  I would also be interested in tracking ALL usage of a cube. Is there a way to do this?

• Koen Verbeeck

  SSC Guru

  Points: 259015

  More actions

  February 24, 2010 at 5:42 am

  #1124214

  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