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.
Open a report in Excel.
Click the Data tab, and then click Connections.
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.
Replace <dbname> with the name of your data warehouse analysis database.
Close the Workbook Connections dialog box and save the file.