Viewing Sheet Information

In Sheet Information, you can view connection and other details for the current worksheet.

In addition to viewing connection details, you can delete Smart View metadata from a sheet or workbook, save the metadata to another sheet, and copy list items from the dialog to another sheet or document.

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

    Depending on the Oracle Smart View for Office data on the sheet, Sheet Information displays details on the following properties:

    • Connected—Connection status; Yes if connected, No if not connected.

    • Sheet Type—Ad hoc, Multiple grid ad hoc, Form, or Function.

      Note:

      For a functions sheet, only this field is displayed with the value as Function in the Sheet Information dialog.
    • Server—The name of the server to which the sheet is connected.

    • Application—The application to which the sheet is connected.

    • Cube—The cube, model, or database to which the sheet is connected.

    • URL—The URL string of the data source provider to which the sheet is connected.

    • Provider—The data source type to which the sheet is connected; for example, Oracle Hyperion Planning, Oracle Hyperion Financial Management, or Analytic Services (Oracle Essbase).

    • Provider URL—The URL string of the data source provider to which the sheet is connected; this property is applicable to Analytic Oracle Hyperion Provider Services 11.1.1.4.x and earlier releases.

    • Friendly Name—For private connections only. The data source connection name specified by the user when creating or editing a private connection, or when adding a shared connection to private connections.

    • Alias Table—The current alias table.

    • Associated Ranges—For multiple grid sheets. The sheet name, application, database, and a unique identifier for each grid in the multiple grid sheet. Multiple grid worksheets apply to supported Oracle Enterprise Performance Management Cloud business processes and Essbase data sources only. To use Sheet Information with multiple grid worksheets, see Sheet Information Guidelines.

    • Description—For private connections only. The optional connection description entered by the person creating or editing the private connection.

    • Form Name—The name of the form to which the sheet is connected. This properties applies when connected to forms in Planning and Financial Management only.

    • Last Retrieved—The date and time that the last refresh was performed on the sheet.

  2. Optional: Select from the following options as needed.
    • Delete—Provides these options for deleting Smart View information, referred to as "metadata":

      • Delete worksheet metadata—Deletes metadata from the current sheet.

        After selecting this option, the Sheet Information dialog displays only these properties: Sheet Type (Empty) and Connected (No).

      • Delete workbook metadata—Deletes workbook metadata. Generally, this is cached metadata that is not visible to users.

        The sheet metadata remains unchanged in the Sheet Information dialog; that is, the same fields that were populated in the previous step are still displayed.

      • Delete all metadata—Deletes both workbook metadata and metadata from all worksheets.

    • Save—Saves the Sheet Information content to an Excel spreadsheet.

  3. Optional: To copy a selected item in the list to the clipboard, press Ctrl+C.

    To copy the entire Sheet Information list, ensure that no items are selected in Sheet Information, then press Ctrl+C. If you have already selected an item in the list, then close Sheet Information, reopen it, and press Ctrl+C.

  4. Click Close.
  5. To view sheet information support by provider, sheet type, and connection status, see Sheet Information Support By Provider.