Quote: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. a) For example, if you want to see the total number of incidents currently open, expand IncidentDimGroup, and then select Incidents Opened. b) 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. 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.
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)
Submit an article or tip