#Olap cube excel upgrade

The first time you analyze a cube with Excel, it can take a few minutes to load. You must have Microsoft Excel 2007 or later installed on the computer running the Service Manager console in order to use the following procedure. Using the PivotTable field list, you can drag and drop fields from the cube into the workbook. You can also save your workbooks into an analysis library. You can use the following procedure to view and analyze a Microsoft Online Analytical Processing (OLAP) data cube from System Center - Service Manager with Microsoft Excel.

View and analyze a Service Manager OLAP data cube with Excel To view a demonstration of creating a report and manipulating data in Excel using data from an OLAP data cube in a PivotTable, see Drill into PivotTable data. You can also go in and out of categories as you continue your analysis.

Select a category or subcategory to add values.ДЄfter you have created your report, you can add any level of additional complexity by sorting, filtering, formatting, and adding calculations and charts.

Select a second category and add it as a column.

Using the PivotTable Field List, select a category and add it as a row.

For example, you can create a straightforward report using the following steps: All the categories, subcategories, and fields are contained in the PivotTable Field List. In turn, most measure groups have many additional levels of subcategories and individual fields. These groups are the highest level of categorization, and they help you examine the data and focus your analysis. PivotTables that appear in Service Manager data cubes include many predefined KPI categories, called measure groups or dimensions. PivotTables can help you quickly and easily create useful reports. When these KPIs are displayed in a PivotTable, the server can send related icons that are similar to the new Excel icon set to indicate status levels that are above or below a certain threshold (for example, with a stop light icon) or whether a value is trending up or down (for example, with a directional arrow icon). KPIs included in Service Manager data cubes are predefined, special, calculated measures that are defined on the server that make it possible for you to track KPIs, such as status (does the current value meet a specific number?) and trend (what is the value over time?). If you save the worksheet to an analysis library, you can later reopen it without having to use the Service Manager console. If you save a worksheet, the data source connection information, KPIs, and any other customizations you have made are saved with it.

After it is opened, the current worksheet contains a snapshot or subset of data from the data warehouse. When you open a report or when you refresh the data connection, Excel uses Microsoft SQLВ Server Analysis Services (SSAS) to connect to the data warehouse to retrieve key performance indicators (KPIs) and other data. Information defining the OLAP data source is embedded in a worksheet. When it is opened, a data cube is presented as a worksheet containing a blank PivotTable report. Service Manager includes predefined Microsoft Online Analytical Processing (OLAP) data cubes that connect to the data warehouse to retrieve data so that you can manipulate it by using Microsoft Excel in a tabular fashion.

#Olap cube excel upgrade

This version of Service Manager has reached the end of support, we recommend you to upgrade to Service Manager 2019.