1. Working with Oracle Smart View for Office
  2. Ad Hoc Analysis
  3. Comments and Unknown Members on Essbase Sheets

Comments and Unknown Members on Essbase Sheets

Data source types: Oracle Analytics Cloud - Essbase

When you are connected to an Essbase provider, you can enable options in Oracle Smart View for Office that allow you to quickly detect:

  • Unknown members on a grid

  • Text typed outside the grid; for example, your own notes on a sheet

In Smart View, cells containing these types of data are referred to as comments.

You can set options in Smart View that allow you quickly and easily spot comment cells, including invalid, or unknown, members in the grid or pertinent notes you may have made on a sheet outside of the grid.

For example, in an Essbase database on the server, a member named "Oregon Coast" member is renamed "Oregon". Smart View tracks this change and shows it to you if you define a cell style to call out comments. Then, you can quickly note the change and correct it in the grid.

To call out comments on Essbase sheets, you set these options in Smart View

  • Enhanced Comment Handling

  • Use Cell Styles

Optionally, define a distinctive cell style for comments.

You can then easily identify comment cells on the sheet, and further select and work with them in the Comment Edit dialog box.

See the following topics for more information on working with comments on Essbase sheets: