Difference between revisions of "Keep Members"
m (Text replacement - "XLCubed" to "FluenceXL") |
|||
| (4 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | + | The Keep menu option allows you to quickly remove unwanted members from a grid report. Select the cells containing the members to keep/exclude and select '''Keep''' from the Grid ribbon (or use the right click option '''FluenceXL > Keep...'''). | |
| − | + | You can then select whether to keep or exclude the selected member(s). This will replace the previous member selection. | |
| − | |||
| − | + | :'''This Member''': The ''selected'' members will be selected explicitly, and all other members removed. | |
| − | The | ||
| − | + | :'''All Other Members''': The ''unselected'' members will be selected explicitly, and all other members removed. | |
| − | The | ||
| − | + | :'''Exclude From Display''': The selected members will be removed from display. You can remove combinations across hierarchies. A red flag will appear on the axis to warn that rows/columns are being restricted - right click on it, '''FluenceXL > Axis > Edit Axis..''' to edit the axis setup. Here you can change the members being excluded, or have the selections driven from an Excel range. | |
| − | A | ||
| − | + | [[Image:Excluded-Slice.PNG|center]] | |
| − | |||
| + | From v8.1, there are three additional options available which are accessed via the Keep menu on the grid ribbon. | ||
| − | + | :'''Keep and Group Members''': A [[MDX_Calculations#Creating Calculated Members|calculated member]] will be created for the selected members, and this will be selected in the report. | |
| − | 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. | + | |
| + | :'''Keep members and create named set''': A [[MDX_Calculations#Creating Named Sets|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. | ||
| + | |||
| + | |||
| + | [[File:Keep-Ribbon-Menu.PNG|800px|centre]] | ||
==See Also== | ==See Also== | ||
Latest revision as of 09:21, 4 July 2023
The Keep menu option allows you to quickly remove unwanted members from a grid report. Select the cells containing the members to keep/exclude and select Keep from the Grid ribbon (or use the right click option FluenceXL > Keep...).
You can then select whether to keep or exclude the selected member(s). This will replace the previous member selection.
- 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. A red flag will appear on the axis to warn that rows/columns are being restricted - right click on it, FluenceXL > Axis > Edit Axis.. to edit the axis setup. Here you can change the members being excluded, or have the selections driven from an Excel range.
From v8.1, there are three additional options available which are accessed via the Keep menu on the grid ribbon.
- 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.
