mdx query: Tail

Lets say that you have a set of tuples and you want to get the very last tuple or some number of last tuples. What would you do? There was a similar question in the news group and some one suggested using Tail function. Its pretty neat and you could use it as follows:

select
    tail(
    [Product].[Product Categories].[Category].members

    ,2
    ) on 0

from
[Adventure Works]

Here, Tail function returns last 2 tuples of category members set.

Happy Cubing,

ZULFIQAR SYED