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

StrToTuple ( string_expression , CONSTRAINED) Returns: tuple Extension:
AS2005
This function constructs a tuple from a string expression. This will fre-
quently be used to transfer a tuple specification that is returned by an ex-
ternal function back to the MDX statement. The string must be a syn-
tactically valid MDX tuple specification relative to the cube in whose con-
text it is executed. When the CONSTRAINED flag is omitted, the
string_expression can contain any MDX expression that results in a
tuple. For example, the following two strings would give identical results
in the customer dimension, where [AZ] is a child of [Southwest], in that
both would result in the Southwest region member:
"([Customer].[Southwest],[Time].[2006])"
"([Customer].[AZ].Parent,[Time].[2006])"
When the CONSTRAINED flag is provided, the string expression must
contain valid MDX tuple composed of named members, or else an error
will result. Of the two examples above, the first would be allowed with the
CONSTRAINED flag while the second one would not. If the error occurs
in evaluating a slicer or axis, the query execution will stop. If the error oc-
curs in evaluating a result cell, the cell will have an error result.
See also: StrToSet (), SetToStr (), TupleToStr (), Members (), .Properties
(), .Name, .UniqueName, IsError ()
StrToValue ( string expression ) Returns: number or string Extension: AS2005,
AS2000
StrToValue ( string_expression , CONSTRAINED) Returns: number or string
Extension: AS2005
This function takes the results of an arbitrary string expression and eval-
uates it as an MDX expression in the current context of the cube or
query. The string expression can be dynamic as well as a fixed string.
When the CONSTRAINED flag is omitted, the MDX expression can be
arbitrarily complicated so long as it returns a single cell value. When the
CONSTRAINED flag is provided, the string expression must contain only
a constant value, or else an error will result. If the error occurs in evaluat-