Comment frames enable you to display comments based on an Excel range in a report. 

A comment frame doesn't need a grid to be able to display comments. ‌Insert a comment frame as usual and under the Main Settings tab, select Show comments based on Excel range. Then select the range the comment frame will be based on, for example, which members you want to see comments and the connection.

  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 you 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 scenerio below, based on a cube with three dimensions: Product, Period, and Country

With the setting enabled, each row is treated like an XL3CubeCommentLookup. For example, it finds 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 enabled, it ‌matches based on the members there:

Bike, 2010 – Would return comments for bikes in 2010 for the any Country member