Keep Members

Revision as of 15:29, 11 May 2015 by Colin Overton (talk) (Created page with "There are several methods for refining member selections based on the existing selections. These can be found under the "Keep" context menu when clicking a member, or under th...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

There are several methods for refining member selections based on the existing selections. These can be found under the "Keep" context menu when clicking a member, or under the "Keep" menu on the grid ribbon.

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.

Retrieved from ‘https://help.fluencexl.com/index.php?title=Keep_Members&oldid=7354’