Difference between revisions of "Comment Frame"
(Created page with "Comment Frames allow for the display of comments within a report. They can be used in 2 main ways: 1) Tied to a specified Grid, where they display all comments for the Grid, f...") |
|||
| (9 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
Comment Frames allow for the display of comments within a report. They can be used in 2 main ways: | Comment Frames allow for the display of comments within a report. They can be used in 2 main ways: | ||
| + | |||
1) Tied to a specified Grid, where they display all comments for the Grid, filtered by the current selections in place. | 1) Tied to a specified Grid, where they display all comments for the Grid, filtered by the current selections in place. | ||
| + | |||
2) Tied to an Excel range containing uniquenames. Typically this approach would be used to display either higher level comments, or to build a report directly on the comments users have entered. | 2) Tied to an Excel range containing uniquenames. Typically this approach would be used to display either higher level comments, or to build a report directly on the comments users have entered. | ||
Comment frames are added from the Visualise menu. | Comment frames are added from the Visualise menu. | ||
| + | |||
| + | [[Image:commentfranen.png|thumb|center|600px]] | ||
| + | |||
| + | ==Comment Frames Based on a Grid== | ||
| + | |||
| + | Right click on the comment frame to edit. Under the 'Main settings' tab, select which grid you would like the comment frame to show comments from. | ||
| + | |||
| + | [[Image:CommentFrames1.PNG|center|350px]] | ||
| + | |||
| + | ==Comment Frames Based on an Excel Range== | ||
| + | |||
| + | A comment frame does not need a grid to be able to display comments. Simply insert a comment frame as usual and under the 'Main Settings' tab, select "Show comments based on Excel range". You will need to select the range the comment frame will be based on (i.e. which members you want to see comments for) and the connection. | ||
| + | |||
| + | [[Image:CommentFrames2.PNG|center|350px]] | ||
| + | |||
| + | When referencing an Excel range, the range must contain ''uniquenames''. This is typically populated by a slicer which has the 'Update range with selection' property set (see [[Dimension Slicers#Updating Excel Ranges|Dimension Slicers]]). The range can be one or more columns. | ||
| + | |||
| + | 1 Column: Comments are retrieved for all members in the range | ||
| + | |||
| + | 2 or more columns: Comments are retrieved for the combinations held in each row. For example, if I select the range B1:C2 shown below, the comment frame will display any comments based on Bikes ''and'' Canada '''or''' Accessories ''and'' Canada. | ||
| + | |||
| + | [[Image:CommentFrames3.PNG|center]] | ||
| + | |||
| + | ===Only show comments...=== | ||
| + | |||
| + | The setting "Only show comments where all members on row match" handles the following scenerio. | ||
| + | |||
| + | Assuming a cube with 3 dimensions: Product, Period & Country | ||
| + | |||
| + | With that setting enabled each row is treated like an XL3CubeCommentLookup (i.e. it would find comments only for the exact slice defined in the rows) any hierarchies not specified assume the default member: | ||
| + | |||
| + | Bike, 2010 – Would return comments for bikes in 2010 for the “All” Country member | ||
| + | |||
| + | Without that setting enable it will just match based on the members there: | ||
| + | |||
| + | Bike, 2010 – Would return comments for bikes in 2010 for the any Country member | ||
| + | |||
| + | |||
| + | |||
| + | ==See Also== | ||
| + | *[[Cube Comments/Version 9.1]] | ||
| + | |||
| + | [[Category:Cube Commentary]] | ||
Latest revision as of 13:08, 1 September 2021
Comment Frames allow for the display of comments within a report. They can be used in 2 main ways:
1) Tied to a specified Grid, where they display all comments for the Grid, filtered by the current selections in place.
2) Tied to an Excel range containing uniquenames. Typically this approach would be used to display either higher level comments, or to build a report directly on the comments users have entered.
Comment frames are added from the Visualise menu.
Contents
[hide]Comment Frames Based on a Grid
Right click on the comment frame to edit. Under the 'Main settings' tab, select which grid you would like the comment frame to show comments from.
Comment Frames Based on an Excel Range
A comment frame does not need a grid to be able to display comments. Simply insert a comment frame as usual and under the 'Main Settings' tab, select "Show comments based on Excel range". You will need to select the range the comment frame will be based on (i.e. which members you want to see comments for) and the connection.
When referencing an Excel range, the range must contain uniquenames. This is typically populated by a slicer which has the 'Update range with selection' property set (see Dimension Slicers). The range can be one or more columns.
1 Column: Comments are retrieved for all members in the range
2 or more columns: Comments are retrieved for the combinations held in each row. For example, if I select the range B1:C2 shown below, the comment frame will display any comments based on Bikes and Canada or Accessories and Canada.
Only show comments...
The setting "Only show comments where all members on row match" handles the following scenerio.
Assuming a cube with 3 dimensions: Product, Period & Country
With that setting enabled each row is treated like an XL3CubeCommentLookup (i.e. it would find comments only for the exact slice defined in the rows) any hierarchies not specified assume the default member:
Bike, 2010 – Would return comments for bikes in 2010 for the “All” Country member
Without that setting enable it will just match based on the members there:
Bike, 2010 – Would return comments for bikes in 2010 for the any Country member
