Clears a dimension member to remove it from the query result set. At least one member must be retained to use this feature. Removed members are not included in the results set, but display on Member Selection dialog as excluded from the query (flagged with a - or minus sign). To add a member back to the query, the exclusion must be from the Selected pane. See also Member Selection Exclusions.
To remove a selected member:
Select one member or a range of members.
Ctrl + click to remove nonadjacent cells
Right-click a dimension label and select Remove Only.
The member is removed from the report and the query. To add the member to the query again, add it from the Catalog to the data layout, or select it on the Member Selection dialog box.