View Qualified Member Names in Cell Notes

In addition to viewing qualified member names in cell information, Oracle Smart View for Google Workspace now provides a convenient way to view them on the grid itself in the form of cell notes in Google Sheets.

Applies to: Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Planning, Tax Reporting

Qualified member names appear in cell notes for non-unique or identical members when the Distinct Member Name Only option is not selected in the Member Name Display field in Smart View Options.

Cell notes are indicated with a triangle in the corner of a cell. You can hover on the cell to view the qualified name. When a member cell with cell note is cut or copied and pasted elsewhere on the sheet, or sorted within the grid, the note is also carried along with the member to its new cell location.

Business Benefit: Users can view the qualified member names for easy identification of non-unique or identical members using cell notes in Google Sheets.

Tips And Considerations

  • It is strongly recommended not to add, delete, or change the text in the note, even though it appears editable. Any change in the note text may result in loss of metadata and may affect the context of the member on the sheet.
  • Qualified member names can be viewed in cell notes only in single ad hoc grid sheets. These are not currently supported in multiple ad hoc grid sheets

Key Resources