Adding Comments to a Data Cell

You can view and create comments on table data cells.

Prerequisites

To set or change the comment limit for your model, go to Start of the navigation path System Next navigation step Administration Limit of comment threads per Model End of the navigation path .

Context

You can leave comments on cells from any type of acquired model. When a story is opened, comment mode is on by default.

Restriction

You can't add comments to table cells from blended models or live data models.

To view the existing comments, add a new comment, and delete any comment, you would need the following permissions.

You should have Read, Create, and Delete permissions for the object-type Comment in the tenant.
You should have Add Comment, View Comment, and Delete Comment permissions on the model to comment on datapoints.
You should have Add Comment, View Comment, and Delete Comment permissions on the story.

Note

If any one permission is missing in the combination, then you won't be able to perform the relevant action.

When commenting on a data point, the data context is taken into account. Only users who share the data context can view the comment. The data context is composed of the following:

All dimensions visible on the table.
Page, chart, and story filters.
Data access control and role-level security.

Note

You can add comments to data cells sourced from restricted measures in a table, however these measures cannot be based on any underlying restricted or calculated measures.

Note

When commenting on a data cell, the data context includes the specific filters on dimensions used to create any underlying restricted measure. The comment will display in other tables and stories that apply the same filter combinations to the dimension.

For example:

You put a comment on a restricted measure based on account values that apply a filter on the region dimension to limit the member to ‘North America’.
The comment will display in other tables or stories that apply the same filters to limit the region dimension to ‘North America’.

When a story is opened, Comment Mode is on by default.

Procedure

Select the data cell to which you want to add a comment.
Right-click and then select Add Comment.
A comment dialog is displayed.
Enter your comment in the displayed dialog and select Place Comment to submit the comment.
The comment is posted as part of a thread - a green wedge shape is displayed at the top right of the cell.

Comments on data points are available for other users as soon as they are made.

The thread and wedge fade away once the story is not set to ( Comment Mode).

If you collapse a hierarchy, existing data point comments may no longer be fully visible. Instead the green wedge in the cell will display as transparent. To access the comment, drill down the hierarchy until a green wedge is displayed.

When you add or remove dimensions, the existing comments will still be visible if the data context of the cell has not changed. In the example below, the comment on the left was created with a Region filter on Canada. On the right, Region has been added to the visible dimension without a filter. The context of the cell remains the same for both scenarios, therefore the same comment is visible.
To reply to a comment on a data point:
1. Choose the wedge in the data cell.
2. Select the displayed comment icon to display the thread to which you want to reply.
3. Enter your text in Reply here ... and select (Send).
Note
A data point comment also displays the original value of the cell if the data value has changed.

Another way to manage data point comments is by using a dedicated commenting column in your table. This column can be used to view and add comments. For more information on how create this column see Adding Calculated Rows and Columns in a Table.

To create a new comment thread or reply to an existing comment thread, select the target cell in the column and enter your comment in the displayed dialog. Select Place Comment to submit the comment.
Note
The dedicated commenting column is created as a new member of the same dimension and hierarchy level as the member it references. You can change this context by referencing a different column in the commenting formula. Changing the drill state or adding a dimension can impact the context of the referenced cell.

Note
Only the most recent comment in a thread will display in a comment column cell. To view an entire comment thread, double-click in the corresponding cell.