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 a Data Platform MVP and 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, and is on the SQL Bits committee.
As well as speaking at SQLBits, he is also a regular speaker at other events including SQL Saturday, SQL Relay, PASS Summit, 24 HOP and SQL Server user groups around Europe.