HI Wim,

level005 is probably your leaf level. My gut feel is that due to ragged rollups being possible, a Leaf member could really exist at any level.

What may make more sense is popping up the options like in the set editor when right-clicking the header:

and when right-clicking a member, maybe the same options as we get on the right-hand pane in the set editor:

These could replace Drill Up and Drill Down imo.

Hi George,

Thanks for replying !

I created a very simple dimension with 1 total and 3 children (level 0). It gives me in the context menu level000 and level001.

level000 then returns the total (consolidated element) and level001 gives me both the total and 3 leaves.

Not particularly helpful when we want to go to the leaves.

Using the chevron on the dimension tile I see level000, level001, Leaf level.

Leaf level does what it name indicates so that's good. But why not having this option in the context menu and why the difference in interface options ?

Agree 100% with your other comments.

HI Wim,

level005 is probably your leaf level. My gut feel is that due to ragged rollups being possible, a Leaf member could really exist at any level.

What may make more sense is popping up the options like in the set editor when right-clicking the header:

and when right-clicking a member, maybe the same options as we get on the right-hand pane in the set editor:

These could replace Drill Up and Drill Down imo.

Hi Wim,

The context menu in the cube viewer cannot modify the current set of members for the hierarchies on the row and column axes.  The context menu options can only change with members from the current set are being displayed.  Most of the options in the context menu act as a filter against the current set of members.  If you need to add or remove members to the current set you need to go into the set editor.

The level options in particular are a bit odd.  level000 is the top level.  If you select level001 it will show all members from the top most level until that level. 

We are planning on revising this context menu at some point in the future to add additional options and make the current options a bit more obvious.

I think the current best option is to make a 'leaves' subset and then users can switch to that subset as needed from the selector tile in the overview area of the cube viewer.

Hi George,

Thanks for replying !

I created a very simple dimension with 1 total and 3 children (level 0). It gives me in the context menu level000 and level001.

level000 then returns the total (consolidated element) and level001 gives me both the total and 3 leaves.

Not particularly helpful when we want to go to the leaves.

Using the chevron on the dimension tile I see level000, level001, Leaf level.

Leaf level does what it name indicates so that's good. But why not having this option in the context menu and why the difference in interface options ?

Agree 100% with your other comments.

HI Wim,

level005 is probably your leaf level. My gut feel is that due to ragged rollups being possible, a Leaf member could really exist at any level.

What may make more sense is popping up the options like in the set editor when right-clicking the header:

and when right-clicking a member, maybe the same options as we get on the right-hand pane in the set editor:

These could replace Drill Up and Drill Down imo.

Hi Stuart,

Thanks for confirming. I will come up with a generic process to create such a subset in all hierarchies of all dimensions.

Something like _L0, everywhere the same name for consistency. Or "hierarchy name_L0" to avoid confusion.

Hi Wim,

The context menu in the cube viewer cannot modify the current set of members for the hierarchies on the row and column axes.  The context menu options can only change with members from the current set are being displayed.  Most of the options in the context menu act as a filter against the current set of members.  If you need to add or remove members to the current set you need to go into the set editor.

The level options in particular are a bit odd.  level000 is the top level.  If you select level001 it will show all members from the top most level until that level. 

We are planning on revising this context menu at some point in the future to add additional options and make the current options a bit more obvious.

I think the current best option is to make a 'leaves' subset and then users can switch to that subset as needed from the selector tile in the overview area of the cube viewer.

Hi George,

Thanks for replying !

I created a very simple dimension with 1 total and 3 children (level 0). It gives me in the context menu level000 and level001.

level000 then returns the total (consolidated element) and level001 gives me both the total and 3 leaves.

Not particularly helpful when we want to go to the leaves.

Using the chevron on the dimension tile I see level000, level001, Leaf level.

Leaf level does what it name indicates so that's good. But why not having this option in the context menu and why the difference in interface options ?

Agree 100% with your other comments.

HI Wim,

level005 is probably your leaf level. My gut feel is that due to ragged rollups being possible, a Leaf member could really exist at any level.

What may make more sense is popping up the options like in the set editor when right-clicking the header:

and when right-clicking a member, maybe the same options as we get on the right-hand pane in the set editor:

These could replace Drill Up and Drill Down imo.