How to Configure the Connection Information in a Report


Updated: May 13, 2016

Applies To: System Center 2012 R2 Service Reporting, System Center 2012 R2 Orchestrator

The first time that you open a report in Microsoft Excel, you must configure the workbook data connection so that it can retrieve information from online analytical processing (OLAP) data cubes in the Service Reporting data warehouse.

To configure a workbook connection

  1. Open a report in Excel.

  2. Click the Data tab, and then click Connections.

  3. In the Workbook Connections dialog box, for each connection, view its properties and replace <LocalHost> with the name of your Service Reporting data warehouse management server.

  4. Replace <dbname> with the name of your data warehouse analysis database.

  5. Close the Workbook Connections dialog box and save the file.

Service Reporting in System Center 2012 R2
Operating Service Reporting
Using Service Reporting Usage Data and Inventory Reports