How to View and Analyze Usage and Inventory Data in Reports
You can use the following procedure to view and analyze an online analytical processing (OLAP) data cube from Service Reporting by using Microsoft Excel. You can also save your workbooks locally and share them with others. By using the PivotTable field list, you can drag fields from the cube into the workbook. For more information about using Excel slicers, see Creating and Using Excel Slicers.
To use the following procedure, you must have Microsoft Excel 2010 or Excel 2013 installed on your computer.
The first time that you analyze a cube by using Excel, the cube can take a few minutes to load.
To view and analyze usage and inventory data
Open File Explorer and browse to the folder where the reports are stored. By default, the folder is InstallationDrive:\Program Files\Microsoft System Center 2012 R2\Service Reporting\Reports.
Open one of the report files. For example, open Usage Report.xls.
For the usage report, information appears on the default tab and shows periodic consumption (including hourly, daily, and monthly) for groups and instances of virtual machines. Various columns of usage data also appear.
For the Server Inventory Report, operating system information appears for virtual machines that tenants are using. The displayed information includes the number of processors and the number of virtual machines.
Optionally, drag fields from the PivotTable field list and create slicers and charts for the usage or license data to generate a more complex analysis.
Optionally, save the workbook to a shared folder or another shared location, such as a Microsoft SharePoint folder.