Checking the number of SSAS get access(connection) for 1 month

• jarupan

  SSCommitted

  Points: 1746

  More actions

  January 19, 2012 at 9:41 am

  #146801

  Hi All,

  Does anyone know how to check number of access to SSAS cube in 1 month?

  Please provide me the link if it already have the solution or your idea.

  Thank you in advance.

  JJ

• Sam Vanga

  SSCommitted

  Points: 1742

  More actions

  January 20, 2012 at 10:45 am

  #1436633

  There is no way unless you have pre-captured this data. There is SSAS flight recorder, but you may not have any luck there too.

  I would suggest enabling SQL profiler trace to capture logging logging events going forward.

  http://msdn.microsoft.com/en-us/library/ms174946(v=sql.105).aspx

  Sam Vanga
  http://SamuelVanga.com