MDX Function and Operator Reference - Professional SQL Server Analysis Services 2005 with MDX - page 1076

the number of elements returned is 1. If Count is less than 1, an empty
set is returned. If the value of the Count is greater than the number of
tuples in the set, the original set is returned.
See also: Tail (), Subset (), Rank (), .Item ()
Hierarchize ( set ) Returns: set Standard
Hierarchize ( set , POST) Returns: set Extension: AS2005, AS2000
Hierarchize () returns the set that it is given after it puts all the members in
each dimension of set into hierarchical order. By default, within each level,
members are put into their database ordering, top down. Children are sorted
to immediately follow after their parents. The optional POST keyword returns
the members in bottom-up rather than top-down order; that is, the children
precede their parents. When the tuples are composed of more than one di-
mension, they are sorted primarily on the first dimension, then on the second
dimension, and so on. Any duplicate tuples are retained.
In Analysis Services, Hierarchize () is similar to sorting on the members' in-
ternal ID property.
See also: Order (), Ascendants (), Ancestor (), .Parent
level .Hierarchy Returns: hierarchy Standard
This function returns the hierarchy that contains the level. Because Ana-
lysis Services semantically treats different hierarchies as different dimen-
sions, this function is essentially equivalent to Level. Dimension.
member .Hierarchy Returns: hierarchy Standard
This function returns the hierarchy that contains the member. Because
Analysis Services semantically treats different hierarchies as different di-
mensions, this function is essentially equivalent to Member. Dimension.
I
dimension .Ignore Returns: member Extension: AS2000