Show TOC

To comment a data cellLocate this document in the navigation structure

Context

With Microsoft Excel functionality, you can add a note to a cell by inserting a comment. You can edit the text in comments and delete comments that you no longer need. You can also choose if the comment text box is shown or hidden in your analysis.

You can add comments to the data cells in the crosstab. The data source must have been refreshed before you add a comment to a data cell. A comment is available internally as long as it is not explicitly deleted. For example, you add a comment to a cell and then change the view on your data. In the new navigation state, the cell with the comment is not visible. As soon as you change the navigation state so that the cell with the comment is again visible in the crosstab, the comment is also available.

The comments are associated with the selection of the cell. The selection inlcudes all selected values for the dimension, for example prompt, filter and background filter values. Analysis stores for each dimension the single member selection if the selection is a single member selection, for example a single value in the prompting definition. For other selections, Anaylsis stores that there has not been a single member selection for this dimension. Note that a comment that is placed on the total cell of a dimension also is considered to not have a single member selection associated for this dimension. A comment is visible in a cell if the cell has for all dimensions the matching single member selection or the comment and the cell both do not have associated a single member selection.

Any hidden selections of a restricted key figure is not taken into account. Instead the key figure id is considered as single member selection.

If you add a comment to a member or header cell in the crosstab, the comment is not available after changing the navigation state.

Note If you create a Microsoft Powerpoint presentation with a crosstab that contains comments, the comments will not be available in the presentation.

Procedure

  1. Make sure that the data source has already been refreshed.
  2. Select the cell that you want to add a comment.
  3. Choose Insert Comment in the context menu.
  4. In the comment text box, type the comment text.
    A small red triangle in the corner of the cell indicates that the cell has a comment attached to it.
  5. To edit an existing comment, select the cell and choose Edit Comment in the context menu.
  6. To keep a comment visible with the cell, select the cell and choose Show/Hide Comment in the context menu.
    The comment text box is shown permantly in your analysis. You can move the text box using drag and drop.
  7. To delete an existing comment, select the cell and choose Delete Comment in the context menu.