Difference between revisions of "Comment Frame"
| Line 9: | Line 9: | ||
[[Image:commentfranen.png|thumb|center|600px]] | [[Image:commentfranen.png|thumb|center|600px]] | ||
| + | ==Comment Frames Based on a Grid== | ||
| − | 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. The range can be one or more columns. | + | 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 | 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 | + | 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]] | ||
Revision as of 10:50, 10 January 2018
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.
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.
