An MDX Question?
OLAP Server User Guide
Configuring icCube
Running icCube
Migrating icCube
Security
Creating Schemas/Cubes
Working with icCube
Reporting Tools Integration
Embedding icCube
Plugins/Extensions
HOWTO
Web Reporting
Web App Integration
Installation
Local Settings
Displaying a Report
Visualization Library
Tutorials
Demos
MDX Documentation
MDX Tutorial (Gentle Introduction)
MDX Functions Reference
MDX Language Reference
MDX OO Extensions
JAVA Integration
R Integration
Reference
icCube Client Library
XMLA Client Library
StrToValue (standard MDX)

Converts a string to its value representation.

Parameters

Name Type Cardinality Default value
  string-expression  one   
  CONSTRAINED  zero-one   

Return

value

Description

Converts a string to its numeric value (e.g. 2.2)

- without the CONSTRAINED flag, the string can contain any valid MDX expression that can be converted into a numeric.

- with the CONSTRAINED flag, only string containing directly a numeric expression can used (e.g. '2.2').

See Also

StrToLevel StrToMember StrToSet StrToTuple

Examples

StrToValue(string)
StrToValue(string) - MDX expression
StrToValue(string, CONSTRAINED)
StrToValue(string, CONSTRAINED)

Special Examples (errors, null, ...)

StrToValue(NULL)

XMLA Properties

Find here the value of the XMLA properties when not specified otherwise.

icCube OLAP version: 3.0.3 03-Mar-2013 14:06:07 GMT