Importing Production Reporting Jobs into Excel

To import Production Reporting jobs into Excel:

1. From the Oracle Smart View for Office ribbon, select Panel.
2. In the Smart View Panel, connect to a Oracle Hyperion Enterprise Performance Management Workspace data source.
3. Navigate to the Oracle Hyperion Interactive Reporting document that you want to import.
4. From the Action Panel, click Open.

   The Import Workspace Document wizard is displayed.

5. In Select a Document, expand the repository, select a Oracle Hyperion SQR Production Reporting job, then click OK.

   The import wizard screen is displayed.

   Note:

   Depending on the document, some screens may not be applicable.

6. If the Specify Parameters screen is displayed, define the job parameters, and click Next.

   Note:

   This screen is displayed only if the job contains parameters.

7. In Preview, to import a page, select a page from the drop-down list located in the upper left of the data object.
8. To import all pages of the job, select All Pages.
9. Select Split Pages across worksheets to display each page on a separate Excel worksheet.
10. Click Finish.

    The document is displayed in Excel.