How to View and Analyze an OLAP Data Cube with Excel

Updated: May 13, 2016

Applies To: System Center 2012 SP1 - Service Manager, System Center 2012 R2 Service Manager, System Center 2012 - Service Manager

You can use the following procedure to view and analyze a Microsoft Online Analytical Processing (OLAP) data cube from System Center 2012 – Service Manager with Microsoft Excel. You can also save your workbooks into an analysis library. Using the PivotTable field list, you can drag and drop fields from the cube into the workbook. For more information about using Excel slicers, see Creating and Using Excel Slicers.

You must have Microsoft Excel 2007 or later installed on the computer running the Service Manager console in order to use the following procedure.

To view and analyze an OLAP data cube with Excel

1. In the Service Manager console, click Data Warehouse, expand the Data Warehouse node, and then click Cubes.

2. In the Cubes pane, select a cube name, and then under Tasks, click Analyze Cube in Excel. For example, select SystemCenterWorkItemsCube and analyze it.

3. When the worksheet opens in Excel, you can drag and drop fields from the PivotTable Field List and create slicers and charts.

   1. For example, if you want to see the total number of incidents currently open, expand IncidentDimGroup, and then select Incidents Opened.

   2. You can add additional fields to generate a more complex analysis. For example, you can add computers from the ComputerDim dimension by selecting the DisplayName field to see the number of incidents that affect different computers.

4. Optionally, you can save the workbook to a shared folder or other shared location, such as the analysis library. For more information about the analysis library, see How to Use the Analysis Library.

Creating and Using Excel Slicers
How to Use the Analysis Library
Using OLAP Cubes for Advanced Analytics