Difference between revisions of "Keep Members"
m (Text replacement - "XLCubed" to "FluenceXL") |
|||
| (One intermediate revision by one other user 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 ''' | + | 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. | You can then select whether to keep or exclude the selected member(s). This will replace the previous member selection. | ||
| Line 7: | Line 7: | ||
:'''All Other Members''': The ''unselected'' 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, ''' | + | :'''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. |
[[Image:Excluded-Slice.PNG|center]] | [[Image:Excluded-Slice.PNG|center]] | ||
| Line 13: | Line 13: | ||
From v8.1, there are three additional options available which are accessed via the Keep menu on the grid ribbon. | 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|calculated member]] will be created for the selected members, and this will be selected in the report. | + | :'''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. |
| − | :'''Keep members and create named set''': A [[MDX_Calculations|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 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. | :'''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. | ||
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.
