In SAP Analytics Cloud, you can view and create comments on table data cells.
Prerequisites
To set or change the comment limit for your model, go to SystemAdministrationSystem Configuration, and update the value for Limit of comment threads per Model.
To add comments to data cells, you need to enable the Allow data point comments option in the Properties section of the builder panel.
Context
You can leave comments on cells from any type of acquired model. When a story is opened, comment mode is on by default.
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 data points.
You should have Add Comment, View Comment, and Delete Comment permissions on the story.
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, table, and story filters.
Data access control and role-level security.
Role-based data security through model privacy can be achieved with simple or complex role definitions. Simple and complex model privacy is defined as follows:
Simple model privacy: When multiple read and write permissions are granted for one dimension or when a single read or write permission is granted for multiple dimensions.
Example 1: In this example, multiple read and write permissions are granted for the Product dimension.
Read access to Product = Drinks
Write access to Product = Alcohol
Example 2: In this example, a single read permission is granted for both Product and Location dimensions.
Read access to Product = Drinks and Location= Drinks
Complex model privacy: When multiple read and write permissions are granted for more than one dimension.
Example: In this example, multiple read permissions are granted for both Location and Product dimensions.
Read access to Location = EMEA
Read access to Product = Drinks
When commenting on data points in models that have role-based data security applied through model privacy and multiple read and write permissions on more than one dimension, consider the following:
When the Model Data Privacy is enabled, only the owner of the model and user roles that have specifically been granted access can see the data. For more information, see Learn About Data Security in Your Model. For information on user roles, see Standard Application Roles.
For a role with multiple read and write permissions, the data aggregation respects the operators used in the model calculation. If AND is selected, the conditions for all attributes must be met for the mapping to be applied. If OR is selected, the conditions for only one of the attributes must be met for the mapping to be applied. Based on the permissions assigned and the resulting data aggregation, the user can comment on the respective data points. Similarly, based on the read permissions and the combined data aggregation assigned to the user's role, a user can read the comments on a certain data point if the data aggregation conditions are met.
If a dimension property has been added to the table axis or used in a filter, which can be a table, page, or story filter, the data context will take into account the dimension property (and its value) when you add a comment.
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.
Procedure
Select the data cell to which you want to add a comment.
Right-click and then select Add Data Point Comment.
A comment dialog is displayed.
Enter your comment in the displayed dialog and select Add Comment to submit the comment.
The comment is posted as part of a thread - a colored 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.
To reply to a comment on a data point:
Choose the wedge in the data cell to display the thread to which you want to reply.
Enter your text in the reply box and then select Add Comment.
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 Create Client Calculations in Table Cells.
Next Steps
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 Add Comment to submit the comment.
You can export a story as a PDF, PPTX or Google Slides file, comment columns in the visible parts of the story tables will also be exported.
You can also export a table with its comment column as a CSV or XLSX file. Note that you need to set Scope to Point of view in the case of CSV file.