To view connection and other details for the current worksheet:
From the Smart View ribbon, click Sheet Info.
Depending on the Smart View 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, or Form.
Server—The name of the server to which the sheet is connected.
Application—The application to which the sheet is connected.
Cube—The cube, 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, Planning, Financial Management, or Analytic Services (Essbase).
Provider Version—The version number of the provider server.
Provider URL—The URL string of the data source provider to which the sheet is connected; this property is applicable to Analytic 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 Essbase data sources only. To use Sheet Information with multiple grid worksheets, see Sheet Information Notes.
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.
Optional: Select the following options as needed.
Delete—Provides these options for deleting Smart View metadata:
Delete worksheet metadata
Delete workbook metadata
Delete all metadata (deletes workbook metadata and all worksheets)
Save—Saves the Sheet Information content to an Excel spreadsheet.
Optional: To copy the 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.
To view sheet information support by provider, sheet type, and connection status, see Sheet Information Support By Provider.
Friendly names are for private connections only. The friendly name is 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.
When using the Sheet Info command with multiple grid worksheets:
To display information on all grids on a multiple grid worksheet, click anywhere outside of the grid boundaries, or select only one cell within a grid.
To display information for only one of the grids on a multiple grid worksheet, select the entire grid, and do not select any cells outside of the grid boundaries.
When connected to Planning, it is not necessary to use the Set as Default Connection option to associate the sheet with an active connective. The association is made automatically immediately after connecting.
The Sheet Information dialog box is not supported, or has very limited support, for the following providers: Oracle BI EE, Financial Reporting, and Strategic Finance.