Hi all,
We are using SQL server 2000 Analysis services with Service pack 4.
Dimension : Geo
Level : country, province, area
We have a calculated member to count the number of Areas for each Geo member
(to be displayed as a row field)
*** Descendants([Geo].CurrentMember, [Geo].[Area]).Count
Since the Geo dimension need to be defined with “Non leaf members visible”,
we ends up with an extra Data member for each level.
How can the formula be modified to exclude those Data members from the
count ?
Thanks for your input.

You can filter out data members with the following MDX

count(filter(descendants(Geo.Currentmember,,LEAVES ), NOT
Geo.currentmember IS Geo.currentmember.parent.DataMember ))'

--
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell

It works perfectly !
Many thanks, Darren.

"Darren Gosbell" wrote: