Viewing Comments in the Sheet

Cloud data source types: Oracle Essbase

On-premises data source types: Oracle Essbase

To view comment cells in an Essbase sheet:

  1. Be sure to complete the steps in Enabling Comment Display in the Sheet
  2. Open a workbook containing a grid, connect to an Essbase provider, and click Refresh.
  3. On the sheet, note the cells containing comments and unknown members.

    In the example in Figure 10-22, cell C4 is an unknown member and Oracle Smart View for Office marked the cell as a comment. The member name was probably changed in the underlying Essbase database. The comment style indicates to us that this member needs attention.

    Additionally, a second comment in the sheet notes that the Oregon Coast member name needs to be changed to Oregon. This comment is a note someone made outside of the grid and confirms to us that the member name has been changed on the server and that the member needs to be manually updated in the grid.

    Figure 10-22 Grid Showing Cells Marked with Comment Style


    Grid showing cells marked with comments
  4. Continue with Editing Comments or Deleting Comments.