Loading presentation...

Present Remotely

Send the link below via email or IM

Copy

Present to your audience

Start remote presentation

  • Invited audience members will follow you as you navigate and present
  • People invited to a presentation do not need a Prezi account
  • This link expires 10 minutes after you close the presentation
  • A maximum of 30 users can follow your presentation
  • Learn more about this feature in our knowledge base article

Do you really want to delete this prezi?

Neither you, nor the coeditors you shared it with will be able to recover it again.

DeleteCancel

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

Comments (0)

Please log in to add your comment.

Report abuse

Transcript of OLAP Cube Documentation Tool

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...
Full transcript