Keep Members

There are several methods for refining member selections based on the existing selections. These can be found under the "Keep" menu on the grid ribbon or the "Keep" context menu when clicking a member. The three additional options available in v8.1, Keep and Group Members, Keep member and create named set and Keep members and create dynamic set are only available via the Keep menu on the grid ribbon.

KeepMembers1.png

This Member

The selected members will be selected explicitly, and all other members removed.

All Other Members

The unselected members will be selected explicitly, and all other members removed.

Exclude from Display

The selected members will be removed from display. You can remove combinations across hierarchies. If you edit the axis setup you can change the members being excluded, or have the selections driven from an Excel range.

Keep and Group Members

A calculated member will be created for the selected members, and this will be selected in the report.

Keep members and create named set

A named set will be created for the selected members, and this will be selected in the report. This can contain members from several hierarchies.


Keep members and create dynamic set

A set of the selected members will be created and selected. This can contain members from several hierarchies. If you double click the hierarchy header you can edit the members selected, or have the selections driven from an Excel range.

See Also