Adding Cell Comments in Financial Management

Cells in ad hoc grids, forms, Smart Slices, and the Query Designer can contain multiple comments. Comments within a cell are differentiated by their labels, which are defined in Oracle Hyperion Financial Management. You cannot create labels in Oracle Smart View for Office.

You select from these defined labels to add and view in Smart View. You cannot edit or delete labels, but you can edit and delete comments.

Viewing and Adding Cell Comments

To view or add cell comments in Financial Management:

  1. Select a cell in the grid.

  2. From the ribbon, select Cell Comments.

    Any comments currently associated with the cell are displayed in the Cell Comments list.

  3. To add a comment, from Cell Comments, select a label from the drop-down menu.

  4. Click Add cell text button.

    The selected cell text label is added to the list of labels.

  5. Click in the field under Cell Text and add a comment.

  6. Repeat as needed to add other labels.

  7. Click OK.

    The labels in the list are now associated with the cell.

Note:

After submitting a cell that has a pipe character ( | ) and caret ( ^ ), the submitting removes all pipe characters and adds "c" after any caret.

Editing and Deleting Cell Comments

To edit or delete cell comments in Financial Management:

  1. Select a cell in the grid.

  2. From the HFM ribbon, select Cell Comments.

  3. From Cell Comments, select a comment in the list and then do one of the following:

    • To edit the comment, select Edit button. After editing, click Edit Complete button.

    • To delete the comment from the cell, select the Delete button. The comment is removed from the list. Deleting a comment removes it only from the selected cell; it remains available for selection from the drop-down menu.

  4. Click OK.

Note:

In Financial Management, you can use functions HsSetText and HsGetText to submit and retrieve cell text to and from the data source. See Functions.