Refreshing Databases in Smart View (Mac and Browser)

The Smart View grid allows you to quickly refresh a database or create a new one.

To refresh a database in Oracle Smart View for Office (Mac and Browser):

1. From the Smart View ribbon, click Home.
2. From the Smart View Home panel, navigate to the root application Dimensions folder.

   If attributes are defined in the application, to refresh attribute dimensions, navigate to the Attribute Dimensions folder.

3. Select the root Dimension or Attribute Dimensions folder, click the Actions button, , and then select Refresh Database from the drop-down menu.

   The Refresh Database dialog box is displayed.

   In the following example, the Dimensions folder is selected, and in the Actions drop-down menu, Refresh Database is selected.

   
   
   

   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.

4. Select the Database check box, and then click Refresh.

   In the following illustration, the Database and Shared Members check boxes are selected. Other options that can be selected for refresh are:

   • Update custom-defined functions

   • Security filters

   • Validate limits

   
   
   

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

5. Click Finish to close the dialog.