- Working with Oracle Smart View for Office
- Books
- Working with Books
- Working with Downloaded Books in Smart View
Working with Downloaded Books in Smart View
-
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 9-7.
-
Click the links in the Table of Contents tab (Figure 9-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 9-8 shows an example worksheet containing a Report.
Figure 9-8 Books Ribbon and Example Report Contained in Book Downloaded to Excel
-
To change the POV for the current Book:
-
Click the Edit POV button in the Books ribbon.
-
In the Select POV dialog, make selections in the drop-down lists for each dimension, and then click OK.
In the following example Select POV dialog, selections were made for the Segments and Fiscal Calendar dimensions.
If aliases are specified for dimensions in the report, you will see the member aliases in the drop-down selection list in the Select POV dialog. In the following example, when changing the POV for the Segments dimension, aliases are displayed for Segment members rather than a product code:
A message notifies you that 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 download the Book once the job is completed. The newly-downloaded Book will show the updated results that reflect the new POV values.
-
-
To view properties for the Book, in the Books ribbon, click
Inspect.
The Book Properties dialog is displayed with the properties of the Book, along with the POV Selections for the Book.
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. 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.
Oracle recommends that the Language setting in Smart View Options match the Language setting in User Preferences in the web interface.
-
To refresh the currently-selected report, in the Books ribbon, click
Refresh.
Use the Refresh command when data is changed in the business process; for example, when a change is made in Planning data.