Parent Child MDX to return all members from all level, Excluding leaf members

#1

Could anyone be kind enough to help me past my mental block?

What MDX syntax will return a set that points to all non leaf members
of a parent child dimension?

Thanks

#2

Something like this:

{ Descendants(MyDim) -
Descendants(MyDim,,Leaves) }

public @ the domain below
www.tomchester.net

"Rob Dennett" <rdennett (AT) apac (DOT) ko.com> wrote

Quote:

Could anyone be kind enough to help me past my mental block?

What MDX syntax will return a set that points to all non leaf members
of a parent child dimension?

Thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Parent Child MDX to return all members from all level, Excluding leaf members

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Parent Child MDX to return all members from all level, Excluding leaf members - 01-21-2004 , 07:29 PM

Re: Parent Child MDX to return all members from all level, Excluding leaf members - 01-21-2004 , 08:29 PM