Cell Comments in Essbase

When you are connected to an Oracle Essbase provider, cell comments are a way for you to detect invalid members on a grid. Cell comments also show you text typed outside the grid; for example, your own notes on a sheet. By enabling cell comments in Essbase, you can quickly and easily spot invalid members in the grid or locate pertinent notes you may have made on a sheet.

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

To work with Essbase cell comments, in Smart View Options, you enable Enhanced Comment Handling, enable Use Cell Styles, and, optionally, define a distinctive cell style for comments. You can then easily identify commented cells on the sheet, and further select and work with them in the Comment Edit dialog box.