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 Limit of comment threads per Model.
, and update the value forContext
You can leave comments on cells from any type of acquired model. When a story is opened, comment mode is on by default.
You can't add comments to table cells from blended models or live data models.
-
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.
If any one permission is missing in the combination, then you won't be able to perform the relevant action.
- All dimensions visible on the table.
- Page, chart, and story filters.
- Data access control and role-level security.
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.
-
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’.
You can add comments to a base account member or a measure in the new model type. However, you cannot add comments on a calculated account member (except of type restricted member).
When a story is opened, Comment Mode is on by default.
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.
When your table has multiple hierarchical dimensions and the comment is added to a lower level member of an inner dimension, you won't see the comment wedge icon when you collapse the outer dimension.
-
You have two dimensions, Account and Region. In Account you expand Income Statement, and in Region you expand All Companies.
You add a comment to North America.
A colored wedge is displayed to indicate that there is a comment.
You then collapse the All Companies hierarchy.
The wedge is still visible, but it is now transparent.
Finally, you collapse the Income Statement hierarchy.
The comment wedge disappears.
Procedure
Results
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.