Cube Comments/Version 8.1

Revision as of 15:52, 6 May 2015 by Csalter (talk | contribs) (Viewing comments)

Cube text commentary was introduced in Version 8.1 it allows users to enter text commentary against data slices this depends on Web Edition running under the SQL Repository

Admin Setup


Grid can be set to display comments and allow comment entry via the Grid properties, once enabled any users of the reports can view and enter comments based on the access they have been granted.

Viewing and entering comments

Comments are displayed as Excel comments - clicking on the cell and selecting the "Comment" grid ribbon item will display a timeline view of all comments and allow a new comment to be entered based on permissions and if the grid allows comment entry

Adding comments



The following formula can be used to either display or enter comments:

  • XL3GridComment - used to display the most recent comments for a given grid, this is useful for providing a "Printable" sheet with comments
  • XL3CubeComment - Can display and allow comment entry for a particular cube slice. This can be combined with slicers to allow comments to be based on the "Current View" of a report, or without any Hierarchy/Members to provide a general workbook comment.

Web Edition

Comments can be viewed and entered in XLCubed Web Edition by right-clicking on a comment enabled grid or XL3CubeComment formula and selecting the "Comment" option

Workbook Level Comments

By default, comments are shared over all workbooks. There is a workbook option to control this, if workbook level comments are enabled you will be given a unique key, this can be edited or shared to allow the same comments to be shared over different workbooks, for example "BUDGET 2015".