Viewing and Editing Analysis Reports in Microsoft Office

You can use Oracle Smart View for Office to access analysis reports and to work with Reporting and Analytics data from within a Microsoft Office application.

  1. On the Reporting and Analytics header, click Download Smart View, and then follow the link to download and install Oracle Smart View for Office.
  2. Start your Microsoft Office application, and then click the Smart View tab.
  3. Click Panel, click Private Connections panel, click the drop-down menu next to the server selection drop-down, and then click Create new connection.

    Figure 19-16 Smart View Panel

    This screenshot shows the location of the menu item for creating a new private connection.
  4. Click Oracle BI EE, enter the URL provided in the Smart View dialog box in Reporting and Analytics, and then click Finish.
  5. Start your Microsoft Office application, and then use the Smart View pane to view and work with the analysis reports to which you have access. The Oracle Smart View for Office documentation contains information and instructions for using Oracle Smart View for Office.