Integrating Microsoft Reports with EPM Workspace

EPM Workspace uses the Web services provided by the Microsoft Reports server directly from the Microsoft Internet Explorer browser to list the contents of the Microsoft Reports server repository. It also uses URL API’s provided by the Microsoft Reports server to render reports.

  To integrate Microsoft Reports with EPM Workspace:

  1. Establish single sign-on.

    • Set up Microsoft Reporting Services to use Windows Integrated Authentication. This allows Microsoft Internet Explorer to authenticate the user using the Windows Domain credentials used to log on to Windows desktop.

    • Ensure that the machine on which Microsoft Internet Explorer is running and the IIS server hosting Microsoft Reporting Web services are in the same Windows domain (similar to an Intranet environment).

  2. Install and configure EPM Workspace.

  3. Install Microsoft Reports or use an existing installation.

  4. On the IIS server hosting the Microsoft Reports Web Services, configure the appropriate IIS Proxy plugins for accessing EPM Workspace.

    The IIS Proxy plugins depend on the application server on which EPM Workspace is deployed. See the Oracle Hyperion Enterprise Performance Management System Manual Deployment Guide for detailed information.

    EPM Workspace should now be accessible through: http://iisserver/workspace, where iisserver is the server on which the IIS hosting the Microsoft Reports Web service is running.

  5. In EPM Workspace, select Navigate, then Administer, then Reporting and Analysis, and then Web Applications.

  6. Right-click Reporting and Analysis Framework Web Application and select Properties.

  7. In the User Interface tab, under Configuration, select Enable Microsoft Report Server Integration.

    Users with the Content Publisher role should be able to see the Import then Microsoft Reports option from the context menu for a folder in the Explorer module. All users should be able to double click a URL object in the repository containing a link to a Microsoft report and view it within a tab in EPM Workspace

Note:

The server from which EPM Workspace is launched must be proxied by the same IIS server as the one hosting the Microsoft Reports Web services for the integration to work. This integration is not supported on Firefox browser.