| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "Axis Sets"
(Created page with "Creating an axis set allows you to easily create a reusable member list, it was introduced in Version 8.1 To do this, right click on a columns or rows dimension label, an...") |
|||
| Line 5: | Line 5: | ||
You will be prompted for a name, and whether or not to used a fixed member list. The difference between using a fixed list and not is: | You will be prompted for a name, and whether or not to used a fixed member list. The difference between using a fixed list and not is: | ||
| − | + | * Standard: Member selections are preserved, so a top 10 will be re-run depending on the grid headers. | |
| − | + | * Fixed: Members are captured as they currently are, so the top 10 list is saved, and a ranking isn't done again if the headers change. | |
You can view or edit the named set from the [[MDX Calculations]] screen. | You can view or edit the named set from the [[MDX Calculations]] screen. | ||
Latest revision as of 11:52, 27 March 2015
Creating an axis set allows you to easily create a reusable member list, it was introduced in Version 8.1
To do this, right click on a columns or rows dimension label, and pick Axis -> Create Named Set.
You will be prompted for a name, and whether or not to used a fixed member list. The difference between using a fixed list and not is:
- Standard: Member selections are preserved, so a top 10 will be re-run depending on the grid headers.
- Fixed: Members are captured as they currently are, so the top 10 list is saved, and a ranking isn't done again if the headers change.
You can view or edit the named set from the MDX Calculations screen.
