SSASMeta – C# App to Log Info About SSAS Objects
User Rating: / 0
PoorBest 
Written by Steve Novoselac   
Friday, 28 August 2009 22:16

I manage some servers that have many cubes. OK, a lot of cubes (60+ on one). I needed some way to output a report of last processed time, last schema update, etc. Now, there are about 5 different ways to do this (one being the SSAS Stored Procedure Project), but this is what I came up with. I wrote a 100 line C# app to take a server name, loop through the SSAS DB’s, cubes, measures, partitions, and dimensions and log info about them.

Read more...

 

Tags: amo, article
 

Pyramid Analytics