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

dependent on the MDX Unique Name Style connection property or the
equivalent server-side setting.
See also: StrToMember (), StrToTuple (), StrToSet (),TupleToStr (),
.Name
member .UnknownMember Returns: member Extension: AS2005
This function returns the member created by AS2005 for handling "un-
known hierarchy" conditions in fact data. Unknown members can be cre-
ated at one of the following levels:
▪ The top level, in attribute hierarchies that cannot be aggregated
▪ The level beneath the (All) level for natural hierarchies
▪ Any level (for other hierarchies)
If the unknown member is requested for a member, then the child of the
given member that is an "unknown member" is returned. If the unknown
member does not exist under the given member , a NULL member refer-
ence is returned.
See also: .CurrentMember, .DefaultMember
Unorder () Returns: set Extension: AS2005
This function relaxes MDX-specified ordering from the tuples or members
of a set. Generally speaking, this function is a hint for optimization of a
set operation. For example, a set that is input to NonEmpty (), TopCount
() or Order () may not have any need to have the sequence of input
tuples preserved. (For functions that sort the input sets, like TopCount ()
and Order (), this is because the stable sorting requirement becomes re-
laxed.) Therefore, NonEmpty (Unorder (set)) may run more quickly than
NonEmpty (set). Note that AS2005 automatically attempts to perform this
optimization for functions like Sum (), Aggregate (), so you may not no-
tice any performance gain attempting to aggregated Unorder ()'d sets.
UserName Returns: string Extension: AS2005, AS2000