1. User's Guide
  2. Books
  3. Working with Books
  4. Working with Downloaded Books in Smart View

Working with Downloaded Books in Smart View

To work with a downloaded Book in Oracle Smart View for Office:
  1. Complete the steps in Importing Books into Smart View.

    The Book is imported in to Smart View and the Books ribbon is displayed, as shown in Figure 10-7.

  2. Click the links in the Table of Contents worksheet tab (Figure 10-7) to view the Reports contained in the Book.

    Each worksheet tab is a report that is part of the Book that was imported and downloaded to Smart View.

    You can also click the worksheet tabs in after the Table of Contents tab to view the various Reports in a Book.

    Figure 10-10 shows an example worksheet containing a Report.

    Figure 10-10 Books Ribbon and Example Report Contained in Book Downloaded to Excel


    Books ribbon and example report, with TOC and report worksheet tabs in Book downloaded into Excel
  3. To edit the prompts for the current Book:
    1. Click the Edit Prompt button in the Books ribbon.

      Edit Prompt button
    2. Follow the procedure in Responding to and Editing Prompts.

    A message notifies you that a refresh operation with the newly-selected POV values is in progress. Click OK in the message. The Jobs Console will display a new job row. You can check the status of the job and the book is automatically downloaded once the job is completed. replacing the currently open book. The newly-downloaded Book will show the updated results that reflect the new POV values.

  4. To change the POV for the current Book:
    1. Click the Edit POV button in the Books ribbon.

      Edit POV button

      Note:

      If a Book contains any reports with relational tables, then the Edit POV option is disabled and will be made available in a future release.
    2. Follow the procedure in Selecting and Editing the POV.

    A message notifies you that a refresh operation with the newly-selected POV values is in progress. Click OK in the message. The Jobs Console will display a new job row. You can check the status of the job and the book is automatically downloaded once the job is completed. replacing the currently open book. The newly-downloaded Book will show the updated results that reflect the new POV values.

  5. To view properties for the Book, in the Books ribbon, click Inspect.

    Inspect button

    The Book Properties dialog is displayed with the properties of the Book, along with the POV Selections and Prompt Selections for the Book.

    Not shown in the following example is the Book Name and Location properties.


    Books Properties dialog for the current Report, showing the POV Selection and Prompts Selection properties. Other properties showing are Created By, Created On date, and Modified By date.

    Click OK to close the Book Properties dialog.

    Note:

    In Smart View, the path information in Location will always display the language set in the web application, even if Smart View is set to a different language. Following is an example of the Book Properties dialog showing the Location property:


    Book Properties dialog showing the Location field as Library/Test

    For example, in the web application, if the Language option in the User Preferences, General tab is set to Japanese, and the Language option in the Smart View Options dialog, Advanced tab, is set to French, then the path information in the Book Properties dialog, Location field, will display as Japanese.

    As a best practice, Oracle recommends that the Language setting in Smart View Options match the Language setting in User Preferences in the web interface.

  6. To refresh the currently-selected report, in the Books ribbon, click Refresh.

    Refresh button

    Use the Refresh command when data is changed in the business process; for example, when a change is made in Planning data.