Show TOC

Excluding MembersLocate this document in the navigation structure

For a specific report, you can choose not to display specific members.

There are two ways of excluding members:

  • You can exclude a member from a report by clicking the Exclude button in the ribbon. The excluding member action is persistent and the excluded members automatically appear in the Excluded Members tab of the Report Editor. If you want to exclude a member and do not want to save this action in the current report, then delete the member row or column, and the member will appear again as soon as you perform a Refresh.
  • You can exclude a member or a combination of members using the Excluded Members tab of the Report Editor.

    Select a dimension, then click Select Members... and select the members in the Member Selector that opens. Repeat this procedure for other dimensions. When you have selected the members you want for the dimensions you want, click the arrow button. The combination of members to exclude is added to the list on the right part of the tab.

    The Remove Members button enables you to remove all the members selected for the selected dimension.

    The Edit Member Selection... button enables you to modify the member selection for the selected dimension and opens the Member Selector.

    The cross-icon button enables you to remove the combination of members to exclude.

    The plus-icon button enables you to add a member selection to the combination of members to exclude.

Note
  • The members of a combination are excluded in the report if they belong to the same axis.
  • A combination of members must include members that do not belong to the same dimension/hierarchy.