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.