You can use the following procedure to view and analyze an OLAP data cube with 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.

You must have Excel or a viewer capable of opening Excel data files installed on the computer running the Service Manager console in order to use the following procedure.

The first time you analyze a cube with Excel can take a few minutes to load.

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 DisplayName field in the ComptuerDim dimension 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.