Importing Production Reporting Jobs into Excel

  To import Production Reporting jobs into Excel:

1. From the Smart View ribbon, select Panel.

2. In the Smart View Panel, connect to a EPM 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 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.