Hi,
Within a dimenion I need to find the first child at the leaf level. In
other words, if I have 5 levels and I'm at the top level my statement would
look something like this incredibly bad example...
[Time.Fiscal].FirstChild.FirstChild.FirstChild.FirstChild
would go down...
2005, QTR1, Jan, Week1, 1st giving me 01/01/2005 as the result

I Also Want the same thing but for LastChild
2005, QTR4, Dec, Week52, 31st giving me 31/12/2005as the result

How can I do this correctly and relatively simply.
Ta!
Paul

Hi Paul,

You could try Descendants() with the LEAVES option:

Descendants([Time.Fiscal].CurrentMember,,LEAVES).Item(0)

and

Tail(Descendants([Time.Fiscal].CurrentMember,,LEAVES)).Item(0)


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

Here's an interesting way to do this:

with
member [Measures].[test] as '1'
select {
[Measures].[My Count]
} on columns, {
topcount(descendants([Domain].[Domain Hierarchy], 2, LEAVES), 1),
bottomcount(descendants([Domain].[Domain Hierarchy], 2, LEAVES), 1)
} on rows
from [Cube]

The trick for this is that:
--
HTH!
Denny Lee
<dennyglee_at_hotmail_dot_com>
space: http://spaces.msn.com/members/denster/



"Paul" <Paul (AT) discussions (DOT) microsoft.com> wrote