To prevent members tagged as shared from being displayed multiple times in the spreadsheet report:
In the member select panel, select a member.
Right-click and select View by, and then Generation Name or View by, and then Level Name.
Select a generation or level name.
Right-click and select Suppress Shared Members.
Related Topics
Applying Member Filtering Rules
Deleting Member Selection Rules
Displaying Aliases
Searching for Members
Selecting Attribute Members
Selecting Query Members
Setting the Maximum Number of Members to Preview
Specifying Latest Period of Time Dimensions
Using Attributes to Select Base Dimension Members
Viewing Member Information