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 box as excluded from the query (flagged with a - or minus sign). To add a member again to the query, the exclusion must be removed from the Selected pane.
To remove a selected member:
Select one member or a range of members.
Use Ctrl + click to remove nonadjacent cells.
Select a dimension label and select Remove Only on the shortcut menu.
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.