Udostępnij za pośrednictwem

StrToValue (MDX)

  • Artykuł

Returns the numeric value specified by a Multidimensional Expressions (MDX)–formatted string.

Syntax

StrToValue(MDX_Expression [,CONSTRAINED] )

Arguments

  • MDX_Expression
    A valid string expression that resolves, directly or indirectly, to a single cell.

Remarks

The StrToValue function returns the numeric value specified by the MDX expression. The StrToValue function is typically used with user-defined functions to return an MDX expression from an external function back to an MDX statement that can be resolved to a single cell.

  • When the CONSTRAINED flag is used, the MDX expression must contain only a scalar value. The CONSTRAINED flag is used to reduce the risk of injection attacks via the specified string. If a MDX expression is provided that is not directly resolvable to a scalar value, the following error appears: "The restrictions imposed by the CONSTRAINED flag in the STRTOVALUE function were violated."
  • When the CONSTRAINED flag is not used, the specified MDX expression can be as complex as desired as long as it resolves to a valid Multidimensional Expressions (MDX) expression that returns a single cell.

Note

Returning the result of an MDX expression as a numeric value can be useful if the value is stored as text and you want to perform arithmetic operations on the returned values.

Example

The following example uses the StrToValue function to return the weight of each bicycle as a value.

WITH MEMBER Measures.x AS 
StrToValue 
   ([Product].[Product].CurrentMember.Properties ('Weight')
   ,CONSTRAINED
   )
SELECT Measures.x ON 0
,[Product].[Product].[Product].Members ON 1
FROM [Adventure Works]
WHERE [Product].[Product Categories].[Bikes]

See Also

Reference

MDX Function Reference (MDX)

Help and Information

Getting SQL Server 2005 Assistance

Change History

Release History

17 July 2006
Changed content:
  • Updated syntax and arguments to improve clarity.
  • Added updated examples.