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

( [Product].[Shipweight].[12],
[Time].[YQMD].[Oct, 2005] )

but if Time appears before Product in the order of dimensions in the cube
designer, the time components of the result tuple will appear first.
However, the Shipweight member will be [12] and the YQMD hierarchy
member will be [Oct, 2005]. The tuple can contain a member from differ-
ent attribute hierarchies of a single logical dimension, like [Time] or
[Product], but if the members do not have a corresponding tuple in the di-
mension, the result tuple is null. If they do, each of the members is re-
tained in the tuple.

If this function is called with no argument, a tuple composed of the root
members for each hierarchy is returned.

Note that this function can be used anywhere, not just in MDX scripts.

See also: Leaves ()

S

Scope

Extension: AS2005

Scope is an MDX Scripting statement that defines a subcube, within which
the actions of other statements is limited. The general syntax is:
Scope subcube ;
statement1 ; [ ... statementN ; ]
End Scope ;

SetToArray ( set [, set … ][, numeric or string expression ])

Standard

The SetToArray () function creates an array as a COM Variant type that holds
an array of values. The only use for this function in OLAP and Analysis Ser-
vices is to pass the constructed array to an external function that is defined as
taking an array.