How do I get the value at a specific level in a hierarchy?

#1

How do I get the value at a specific level in a hierarchy?

I can get the name:
[hierarchy].[level name].CurrentMember.Name

I want to get the value for that level and have it cascade to any
descendents.

#2

Try the Descendants function - use that as your "set" and then use an
Aggregate function like Sum or Average.

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

How do I get the value at a specific level in a hierarchy?

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

How do I get the value at a specific level in a hierarchy? - 07-17-2006 , 03:30 PM

Re: How do I get the value at a specific level in a hierarchy? - 07-18-2006 , 10:52 AM