Who’s been using your Cube?

To keep track of how many people are actually using the results of your hard work…
You have two considerations:

1. Turn on Logging on your Analysis Services Cube
2. Actually query that log…

For the first step, you need to right-click the Analysis Services Machine name in the SSMS. Choose properties. You’ll see 4 settings of interest:
…CreateQueryLogTable (set it to True)
…QueryLogConnectionString (Fill this out, following the prompt)
…QueryLogSampling (set this to 10 and you’ll get every 10th olap query get logged)
…QueryLogTableName (“OlapQueryLog” would an example)

For the second step, see the code below:

Leave a Reply

Your email address will not be published. Required fields are marked *