Export (0) Print
Expand All

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

  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.

See Also

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.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
© 2015 Microsoft