Getting only leaf members

#1

Is there any MDX functions wich return only the leaf members ov a parent
child dimension?
Thank you
Andrea

#2

Select
Filter(account.members,IsLeaf(account.currentmembe r))
on 0 from budget

HTH
JÃ¶rg

"Andrea Temporin" wrote:

Quote:

Is there any MDX functions wich return only the leaf members ov a parent
child dimension?
Thank you
Andrea

#3

thanks
Andrea
"Joerg" <Joerg (AT) discussions (DOT) microsoft.com> ha scritto nel messaggio
news:EE72905D-7DA8-407F-B8E0-A0559E794ABF (AT) microsoft (DOT) com...

Quote:

Select
Filter(account.members,IsLeaf(account.currentmembe r))
on 0 from budget

HTH
Jörg

"Andrea Temporin" wrote:

Is there any MDX functions wich return only the leaf members ov a parent
child dimension?
Thank you
Andrea

#4

Just another question, can you tell me something more about the syntax
"SELECT [...] ON 0 FROM [...]" ?
Thank you very much
Andrea

"Joerg" <Joerg (AT) discussions (DOT) microsoft.com> ha scritto nel messaggio
news:EE72905D-7DA8-407F-B8E0-A0559E794ABF (AT) microsoft (DOT) com...

Quote:

Select
Filter(account.members,IsLeaf(account.currentmembe r))
on 0 from budget

HTH
Jörg

"Andrea Temporin" wrote:

Is there any MDX functions wich return only the leaf members ov a parent
child dimension?
Thank you
Andrea

#5

You can get the set of leaves by using: Descendants([Any level or
member of dimension],, Leaves).

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

Getting only leaf members

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

Getting only leaf members - 04-08-2005 , 02:21 AM

RE: Getting only leaf members - 04-08-2005 , 05:45 AM

Re: Getting only leaf members - 04-08-2005 , 08:02 AM

Re: Getting only leaf members - 04-08-2005 , 10:06 AM

Re: Getting only leaf members - 04-08-2005 , 10:29 AM