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 Start of the navigation path System Next navigation step Administration System Configuration End of the navigation path , and update the value for Limit of comment threads per Model.

Context

You can leave dimension comments on dimension member combinations from any type of acquired model.

Note

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

Note

Dimension comments are only supported on tables with the option of Optimized Presentation enabled.

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 dimension member combinations.
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 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.

Example

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.

Note

Dimension comments will be shown for each member of dimensions which are in the row axis but not defined in the dimension comment formula.

Example

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.

Note

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

Select a member cell of a dimension specified in the column axis.
Right-click the cell, select Add Calculation, and then select Dimension Comment.
A dimension comment column is displayed as the first column to the right of dimensions in the row axis.
To edit the dimension comment formula, select the dimension comment column header cell and make sure Formula Bar from the tool bar is selected.
Dimensions in the row axis and version dimension are filled in the formula by default, and you can modify the dimensions in the formula based on your needs.
Double-click a dimension comment cell and then edit it just like the way you edit data cells.

Note

Different from data cells, there is no background color indicating value change for dimension comment cells.

Note

The maximum number of characters in a dimension comment cell is 255.

Note

As opposed to comments made on data points, you can delete dimension comments by using a keyboard shortcut, or just entering/pasting empty value.

Note

Editing dimension comments from the formula bar is not supported.
Copy and paste dimension comments.
You can copy and paste dimension comments within the same table, across tables within the same story, from tables in another story, and from external sources like an Excel spreadsheet.
Note
- Pasted dimension comments will overwrite existing ones.
- Copying and pasting empty strings will delete existing dimension comments.
- When copying and pasting formatted text to dimension comment cells, the source format will be lost.
- When copying and pasting a dimension comment cell to a custom cell, cell reference will not be created and the custom cell is set to read-only.

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.

Note

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.