You can suppress shared members for generation and level names only so that shared members do not appear multiple times in the spreadsheet.
Clearing All Member Selections
Reordering Member Display in Worksheets
Selecting Members Using Attributes
Selecting Members to Add to Worksheets
Specifying Latest Period To-Date