Hi

How can i retrieve a members natural index in the hierarchy now the member
property for ordinal is deptreciated?

If I can use the item(index) function to reteive a member surely I must be
able to retrieve the index from a member property??

I've got a feeling I'm missing something pretty obvious here

TIA

Have you had a look at the RANK() function?

from BOL: http://msdn2.microsoft.com/en-us/library/ms144726.aspx

Rank(Tuple_Expression, Set_Expression [ ,Numeric Expression ] )

If Numeric_Expression is not specified, the Rank function returns the
one-based ordinal position of the specified tuple.

If that does not help, try posting an example of why you need the
ordinal and someone might be able to come up with another alternative.

HTH

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

In article <ejKWZp6eGHA.1264 (AT) TK2MSFTNGP05 (DOT) phx.gbl>, gilly1409
@hotmail.com says...