Adding Dimension Comments to a Table
You can view and create dimension comments that record textual descriptions of dimension member combinations in a table.
Prerequisites
To set or change the comment thread limit for your model, go to Limit of comment threads per Model.
, and update the value forContext
You can leave dimension comments on dimension member combinations from any type of acquired model.
You can't add comments to table cells from blended models or live data models.
Dimension comments are only supported on tables with the option of Optimized Presentation enabled.
-
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 dimension member combinations.
-
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.
When you work on dimension comments, the dimension comment context is taken into context. It refers to all the dimensions defined in the dimension comment formula, which are specified either in the row axis or in a filter. When you add or remove dimensions, the existing dimension comments will still be visible if their own contexts have not changed.
First scenario: the dimension comment in the first screenshot is created with a Product filter on Athletic Shirts.
Second scenario: Product has been added to the visible dimension without a filter.
The context of the dimension comment remains the same for both scenarios, therefore the same dimension comment is visible.
Since dimension Product is in the row axis but not defined in the dimension comment formula, dimension comments are shown for each member of this dimension, with comment cells sharing the same context showing the same dimension comment.
If multiple cells are pasted to these comment cells, the last pasted cell will prevail and its value will be shown in all these target comment cells.
The data cells highlighted in the previous example are pasted to dimension comment cells, and “51,282.05” is shown as the dimension comment for all cells.
Hierarchy is not taken into account for dimension comments. For example, a dimension comment on a parent member will always be shown regardless of which child members are selected, because child members are not stored as dimension comment context for the parent member. Besides, dimension comments won’t change after hierarchy is switched.
Procedure
Results
Your dimension comments are created.
Next Steps
You can export a story as a PDF, PPTX or Google Slides file, and existing dimension comments in the visible parts of the story tables will also be exported.
You can also export a table with all its dimension comments as a CSV or XLSX file. Note that you need to set Scope to Point of view.
What you should know about dimension comments:
-
In dimension comment formulas, you can't define time dimensions and dimensions with level-based hierarchies.
-
If you have a property of a user-managed time dimension with semantic type of Others and use it as a level in a time hierarchy, dimension comments are not supported when the hierarchy is adopted.
-
Dimension comments made on members in a hierarchy based on fiscal year are not shown for their corresponding members when you switch to a hierarchy based on calendar year, and vice versa.