How to Configure the Connection Information in a Report
Updated: November 1, 2013
Applies To: System Center 2012 R2 Orchestrator, System Center 2012 R2 Service Reporting
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
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.
For additional resources, see Information and Support for System Center 2012.
Tip: Use this query to find online documentation in the TechNet Library for System Center 2012. For instructions and examples, see Search the System Center 2012 Documentation Library.