CODEWITHSUNDEEP
ssasssas-tabularmsbissas-2008ssas-2012
Vikas Gupta
Vikas Gupta

Reputation: 1343

How can we get the usage of measures and dimensions in SSAS cube?

We are struggling to find the usage of measures and dimensions in SSAS cube.

Objective: To have a statistical dashboard to find the unused or most used measures and dimensions.

I have got help from https://blogs.perficient.com/microsoft/2011/06/ssas-usage-statistic-dashboards/ to enable the OLAPQueryLog table.

OLAPQueryLog table provides the following information

  1. MSOLAP_Database
  2. MSOLAP_ObjectPath
  3. MSOLAP_User
  4. Dataset
  5. StartTime
  6. Duration

We are using Dataset field to only find the usage of our columns but not measure.

I have also tried getting the users current sessions using DMX query.

Select * from $System.discover_sessions

but this is returning me the currently active sessions.

How can i get the historic sessions?

Does any one has solution for it?

Thanks,

Upvotes: 1

Views: 2782

Answers (1)

Vikas Gupta
Vikas Gupta

Reputation: 1343

Thanks guys, for your help.

I have achieved it Tabular Cubes using:

  1. Enabling Event Logs using Extended Events
  2. Using only Query End Event Log to get the statistics
  3. C#: Using C# to read details of the event
  4. By Using TextData, and regular expression in C#, extracting measures and dimensions

Upvotes: 1

Related Questions