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

member .NextMember Returns: member Standard
See description of .PrevMember
NonEmpty ( set1 [, context_set ]) Returns: set Extension: AS2005
This function returns the tuples of set1 that are non-empty across the
tuples of context_set. Non-emptiness is a characteristic of cells, not
tuples. The measure(s) to use in determining whether or not a tuple is
"empty" are found in one of the sets. If the context_set is omitted, the
current context of all current members from all dimensions not part of
set1 is used. Even if context_set is provided, the current context of all at-
tributes is present, whether or not they explicitly participate in either of
the sets.
See also: NonEmptyCrossJoin (), Filter (), Count (), NonEmptyCount (),
IsEmpty ()
NonEmptyCrossJoin ( set1 , set2 [, set3 … ] [, set-count ]) Returns: set Exten-
sion: AS2005, AS2000
This function returns the nonempty cross-join of two or more sets. It is
based on data actually present in fact tables. This means that it filters out
all tuples involving calculated members.
Note that while this function is supported in Analysis Services 2005, Mi-
crosoft is recommending that you use NonEmpty instead.
Nonemptiness is a characteristic of cells as opposed to tuples.
NonEmptyCrossJoin () takes a different approach to specifying the cells
than the other functions that deal with empty/nonempty cells associated
with tuples. If the set-count is present, then the number specified for it
will be used as the number of sets (starting at set1 ) to actually cross-join.
The remaining sets listed will be used to form the slices used to find the
cells that are nonempty. (Any dimensions not listed will have their current
member used to determine cells.)
If the set-count parameter is provided, then only that number of sets (in
the order that they appear) will contribute tuples to the resulting set. The
remaining sets will provide the context or add members for consideration
in the nonemptiness. The other sets may have only one member, or they