MDX query to to count the members in a dimension

#1

hi All,

i am new to MDX query,,,, i want the count of all the leaf level
members in a dimension.

thanks
Raj

#2

using AS2005:
count(leaves(dimension))

using AS2000:
count(dimension.[lowest level].members)

"Raj" <raj.atla (AT) wachovia (DOT) com> wrote

Quote:

hi All,

i am new to MDX query,,,, i want the count of all the leaf level
members in a dimension.

thanks
Raj

#3

jeje...i am using Hyperion Essbase.

#4

I think the syntax is the same.

get the MDX Solutions
the new edition cover both AS2005 & Hyperion syntaxes.

"Raj" <raj.atla (AT) wachovia (DOT) com> wrote

Quote:

jeje...i am using Hyperion Essbase.

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

MDX query to to count the members in a dimension

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

MDX query to to count the members in a dimension - 03-15-2006 , 04:37 PM

Re: MDX query to to count the members in a dimension - 03-15-2006 , 04:42 PM

Re: MDX query to to count the members in a dimension - 03-15-2006 , 05:08 PM

Re: MDX query to to count the members in a dimension - 03-15-2006 , 05:59 PM