Importing Books
You can import books to download and work on them in Oracle Smart View for Office (Mac and Browser).
Before you begin importing books,
you should have already connected to a data source and launched the EPM Books panel, as described in Launching the EPM Books Panel.
To import books:
-
In the list of books in the EPM Books panel, click
next to the book that you want to import.
The import process begins.For each book that you import, a separate row is added to the Jobs Console pane in the EPM Books panel. The following example shows the EPM Books panel with two jobs in the Job Console, one in progress with Started status and one with Completed status. The panel is expanded so that you can see all columns in the Jobs Console.Figure 11-6 EPM Books Panel Showing Jobs in the Jobs Console
-
In the Jobs Console, , click
to refresh the job status of the import process for your book.
The job status icons for individual jobs are:- —Job is in progress. Click to update the job status.
—Job is completed. Click to download the job.
—An error has occurred. Click to view the error message.
-
In the list of jobs in the Jobs Console, click next to a completed job to download it in to Oracle Smart View for Office and then click
Yes at the prompt to confirm the download.
Note:
Only reports are included in the book imported and downloaded into Excel. Inserted books or third-party documents, such as PDFs or Microsoft Word documents, are not included in the Excel Book import.
The book opens in Excel and a table of contents sheet is generated with links to the individual report sheets in the workbook, as shown in the following example.Figure 11-7 Example of TOC Sheet and Worksheet Tabs in Book Downloaded into Excel 365
