Refreshing Databases in Smart View for Office

The Oracle Smart View for Office grid allows you to quickly refresh a database.

To refresh a database in Smart View:

1. From the Smart View ribbon, click Panel.
2. From the Smart View Panel, select Planning.
3. Expand the Dimensions folder to view the application dimensions in the folder.

   If attribute dimensions are defined, they are displayed in the Attributes folder.

4. Right-click the root Dimension or Attributes folder and select Refresh Database.

   The Smart View Refresh Database dialog box is displayed.

   Tip:

   The database refresh cannot be completed while a rule type job is running or in progress. Check the Job Console, either in the web or in Oracle Smart View for Office (Mac and Browser), for any jobs running against the database. When all jobs are complete, then perform the database refresh.

5. Click Refresh.

   A progress bar is displayed, indicating the percentage of steps completed for the refresh or create operation.