Databases Reference
In-Depth Information
The constructed array will hold values of only one type (which might be, for
example, long integer, single float, double float, or string). That type is de-
termined by the type of the first value that is actually placed into the array.
The dimensionality of the array that is created is determined by the number of
sets that appear as arguments to SetToArray (). If the optional numeric or
string expression is provided, it is evaluated over the cross-join of the sets,
and the values are placed in the array. If the numeric or string expression is
not provided, then the cross-join of the sets is evaluated in the current con-
text, and the results obtained are placed in the array.
SetToStr (
set
)
Returns: string Standard
This function constructs a string from a set. It will frequently be used to
transfer a set to an external function that knows how to parse the string,
even though the string is syntactically suitable for OLAP Services to
parse into a set. OLAP Services constructs the string as follows: The first
character is { and the last character is }. Between the braces, each tuple
is listed in order. A comma and a space separate each tuple from the
next name. If the set contains only one dimension, then each member is
listed using its unique name. If the set contains more than one dimen-
sion, then each tuple begins with an open parenthesis ["("] and ends with
a closing parenthesis, ")." The unique name of the member from each di-
mension is listed in the order of the dimensions in the set, separated by a
comma and a space. For example, in a Time dimension that has three
years, the expression
SetToStr ([Time].[Year].Members)
would yield the following string:
"{[Time].[All Times].[1998], [Time].[All
Times].[1999], [Time].[All
Times].[2000]}"
Moreover, the expression
SetToStr ( {([Time].[1998],
[Customer].[Northeast]), ([Time].[1999],
[Customer].[Southwest])} )
yields the following string:
Search WWH ::
Custom Search