Editing Web Analysis Documents

To edit Oracle Hyperion Web Analysis documents:

  1. Select a page (Excel) or an image (Word or PowerPoint).
  2. From the Oracle Smart View for Office ribbon, click the arrow in The Connections icon, then select Reporting and Analysis Document, and then Edit.
  3. If database credentials are not saved with the Web Analysis document, then the Specify Database Credentials page is displayed. In Specify Database Credentials, enter the user name and password, or select Skip, and then click Next.

    Tip:

    You can select Save Credentials to save them with the Web Analysis document.

  4. Select a spreadsheet, chart, or pinboard to import.
  5. In Preview, to import a page, select a page from the drop-down list located in the upper left of the data object.
  6. Select All Pages to import all pages of the document. Leave the box cleared to import only the current page.
  7. Select Split Pages across worksheets to display each page on a separate worksheet (Excel only).
  8. In Import Document As, select:
    • Fully Formatted (Excel only)

    • Query-Ready (Excel only)

    • Image (Word and PowerPoint)

  9. Click Finish.