first child

#1

Hi

I know how to get a first child of a member. member.FIRSTCHILD.

My question is how can I get a first child of a member at a specified

level.

for example if i have hirarchy like

year

quarter

month

week

day

how can i write mdx to get the first child of 1998 at week level.

Thanks

--
Posted via http://dbforums.com

#2

Using the OpeningPeriod function. In your case, you would
write:

openingperiod([Week],[1998])

HTH,
Brian
www.geocities.com/brianaltmann/olap.html

Quote:

-----Original Message-----

Hi

I know how to get a first child of a member.
member.FIRSTCHILD.

My question is how can I get a first child of a member at
a specified

level.

for example if i have hirarchy like

year

quarter

month

week

day

how can i write mdx to get the first child of 1998 at
week level.

Thanks

--
Posted via http://dbforums.com
.

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

first child

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

first child - 08-26-2003 , 01:16 PM

first child - 08-26-2003 , 03:10 PM