O'Reilly logo

Microsoft System Center 2012 Service Manager Cookbook by Andreas Baumgarten, Anders Asp, Samuel Erskine, Dieter Gasser, Steven Beaumont

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Analyzing data with Microsoft Excel

Online Analytical Processing (OLAP) cubes are a new feature in SCSM 2012 that leverages the Service Manager Data Warehouse infrastructure to provide self-service Business Intelligence capabilities to the end user.

An OLAP Cube is a data structure that overcomes limitations of relational databases by providing rapid analysis of data. Cubes can display and sum up large amounts of data while also providing users access to the most granular of data. These cubes are stored in SQL Server Analysis Services databases. Self-service BI tools such as Excel and SQL Server Reporting Services can target these cubes and allow the user to analyze the data from multiple perspectives.

In this recipe, we are going to show you how ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required