Difference between revisions of "Keep Members"
| Line 19: | Line 19: | ||
===Keep members and create dynamic set=== | ===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. | 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== | ||
| + | * [[Calculations Overview]] | ||
| + | |||
| + | [[Category:Grid Reporting]] | ||
Revision as of 16:53, 16 June 2015
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.
Contents
[hide]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.
