Arc - Subset Editor - option for "Root Elements" subset
Is your feature request related to a problem? Please describe.
Roy Burton:
When opening a subset and there is no default subset for the dimension, all elements are shown. This is not always the desired behaviour.
Describe the solution you'd like
Roy Burton:
The ability to select a "root elements" subset to be shown {[dim].[hier].levels(0).members}.
Also, it would be useful to have a "Root Elements" button, similar to the subset all button.
Describe alternatives you've considered
This can be achieved manually, but only after waiting for the initial load to complete.
Additional context
This feature is more complex than it might seem at first sight.
To maintain backward compatibility, it would need to be implemented as a user preference that defaults to the current behaviour.
However, "Root Elements" may not be the only preferred alternative to "Subset All" -- some users may like to specify "Root Elements + Direct Children", "Leaf Elements", "First Hierarchy" or other options. Perhaps Arc should allow the user to specify a custom MDX string, or let the user select between a number of preset MDX strings?
You could also make arguments for and against having this setting maintained per-dimension instead of being a global behaviour. In this case, it would be set in the subset editor and remembers for future loads of the same dimension.