OLAP Cube Documentation in SSRS part 2
September 27th, 2010 in Analysis Services, Blog, Business Intelligence, Reporting Services, SQL ServerIn my previous post I described how to create a number of stored procedures that use Dynamic Management Views (DMVs) to return the metadata structure of an SSAS 2008 OLAP cube, including dimensions, attributes, measure groups, BUS matrix etc. In this post I’m going to use those procs to create a set of SSRS 2008 reports that will serve as the automated documentation of your cube. I’m going to make the following assumptions:…
» Read more