SQLBits 2011

Automating SSAS cube documentation using SSRS, DMV and Spatial Data

This session will show how to use DMVs (data management views) to query the OLAP cube structure, and then use SSRS to create a set of interactive reports including the BUS matrix, and using spatial data to generate automated star schemas.
Most developers’ attitude to documentation is well known! So why not make it interesting and automate it using some of the new features available in SQL Server? This session will show how to use DMVs (data management views) to query the OLAP cube structure, and then use SSRS to create a set of interactive reports including the BUS matrix, and using spatial data to generate automated star schemas. After you’ve done this once it will provide live structure documentation, automatically updating itself every time the cube structure is updated.