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.
Presented by Alex Whittles at SQLBits VIII
  • Downloads
  • SpeakerBIO
    Alex_Whittles.jpg
    Alex is the owner and lead consultant at Purple Frog, a SQL Server Business Intelligence consultancy with clients including Barclays Capital and Confused.com. He specialises in all aspects of dimensional data modelling, data warehousing and cubes 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 and SQL Server user groups around the country.
    http://www.PurpleFrogSystems.com http://www.purplefrogsystems.com/blog/feed/
  • Video