It appears that your browser does not support JavaScript, or you have it disabled. This site is best viewed with JavaScript enabled. If JavaScript is disabled in your browser, please turn it back on then reload this page. If your browser does not support JavaScript, click here for a page that doesn't require javascript.

Automating SSAS cube documentation using SSRS, DMV and Spatial Data

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.

Alex is the owner and lead consultant at Purple Frog, a SQL Server Business Intelligence consultancy in the UK. He specialises in dimensional data modelling, data warehouse design, ETL systems, OLAP cubes, MDX and DAX using the SQL Server stack.
Alex has an MSc in Business Intelligence, runs the Midlands SQL Server User Group and the Birmingham SQL Relay conferences.
As well as speaking at SQLBits, he is also a regular speaker at other events including SQL Saturday, SQL Relay and SQL Server user groups around Europe.