Sheet Information Guidelines

  • 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, consider the following best practices:

    • 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.

  • When you associate a connection to an ad hoc worksheet using Set Active Connection, members may disappear from the worksheet when you refresh. Instead of associating a connection, as a best practice, perform direct ad hoc analysis on the worksheet.

  • The Sheet Information dialog box is not supported, or has very limited support, for the following providers: Oracle Business Intelligence Enterprise Edition, Oracle Hyperion Financial Reporting, and Oracle Hyperion Strategic Finance.