Viewing Sheet Information

You can view useful information about the sheet such as connection details, connection status, sheet type, and last connected date and time. You can also save this information to an html file or delete the sheet's metadata, if not required.

To view sheet information:

1. From the Smart View ribbon, select Sheet Info.

   If you see a notification indicating that Smart View wants to display a new window, click Allow.

   Ensure that you are connected to your data source, else the Sheet Info dialog will not open.

2. Depending on the data on the sheet, view the following information displayed in the Sheet Info dialog box:

   • Connection

     • Server: Name of the server to which the sheet is connected
     • Application: Application to which the sheet is connected
     • Cube: Cube, model, or database to which the sheet is connected
     • URL: URL string of the data source provider to which the sheet is connected
     • Provider: Data source type to which the sheet is connected.
     • Alias Table: Current alias table
     • Form Name: Name of the form to which the sheet is connected. This property applies when connected to forms in Oracle Enterprise Performance Management Cloud applications.

   • General

     • Sheet Type: Ad hoc or form
     • Last Retrieved: Date and time when the sheet was last refreshed

3. Select the following options as needed:

   • Delete: Provides these options for deleting Smart View metadata:

     • Delete worksheet metadata deletes all Smart View metadata in the active sheet.
     • Delete workbook metadata deletes all Smart View metadata in the active workbook.

     Note:

     The Delete operation cannot be undone.
   • Save: Saves the sheet information content to an html file.
4. Click Close to close the Sheet Info dialog box.