Present Online
Send the link below via email or IM to invite your audience
Start the presentation
- Invited audience will follow you as you navigate and present
- This link expires 10 minutes after you close the presentation
- A maximum of 30 users can view together your prezi
- Learn more about this feature in the manual
Download prezi for:
Present offline on a PC or Mac.
- Embedded YouTube videos need an active Internet connection to play.
- Portable prezis are not editable.
Edit and present offline with Prezi Desktop
- To open PEZ file, please download Prezi Desktop
Do you really want to delete this prezi?
Neither you, nor the coeditors you shared it with will be able to recover it again.
Make your likes visible on Facebook?
Connect your Facebook account to Prezi and let your likes appear on your timeline.
You can change this under Settings & Account at any time.
OLAP Cube Documentation Tool
An automated documentation tool for visualising and exploring SSAS OLAP cubes, using DMVs, Spatial Data and SSRS
by Alex Whittles
on 6 April 2011
Tweet
Prezi Transcript
DOCUMENTATION!!! Alex Whittles Business Intelligence Consultant Alex@PurpleFrogSystems.com
www.PurpleFrogSystems.com
www.PurpleFrogSystems.com/blog
Twitter.com/PurpleFrogSys Data Warehouses Dimensional Data Modelling OLAP Cubes MDX ETL Systems Reporting Systems What do we do? !!! AUTOMATED !!!
DOCUMENTATION DMV Spatial Data Tablix Stored Procedure Dynamic
Management
Views SQL Server 2005
Added SSAS DMV in SQL 2008
Query in the MDX Window SELECT * FROM $SYSTEM.MDSCHEMA_CUBES
SELECT * FROM $SYSTEM.MDSCHEMA_DIMENSIONS
SELECT * FROM $SYSTEM.MDSCHEMA_MEASUREGROUPS
SELECT * FROM $SYSTEM.MDSCHEMA_MEASURES DEMO 1 / 11 32.7° x = Sin(32.7) * Radius y = Cos(32.7) * Radius Alex Whittles www.purplefrogsystems.com/blog/
http://bit.ly/cubedoc
http://bit.ly/cubedocslides
Alex@PurpleFrogSystems.com
Twitter/PurpleFrogSys THANKS! Frog Blog! DEMO SSRS 6 cubes 80 Dimensions 30 Fact Tables 20 Role Playing Dimensions 1 Hour per Dimension/Fact = 3 weeks writing!! CubeDoc took a few hours...
See the full transcript
