STRTOMEMBER
Description:
This function is used to return the member specified by a Multidimensional Expressions (MDX)-formatted string.
Syntax:
StrToMember(Member_Name [,CONSTRAINED] )
Return type:
MEMBER
Parameters:
Parameter | Description |
|---|---|
Member_Name | It is a valid string expression specifying, directly or indirectly, a member. |
Example:
WITH MEMBER [Measures].[Category Param] AS "[Product].[Product Categories].[Bikes]"
MEMBER [Measures].[Dynamic Sales] AS
(StrToMember([Measures].[Category Param]), [Measures].[Internet Sales Amount])
SELECT {[Measures].[Category Param], [Measures].[Dynamic Sales]} ON COLUMNS
FROM [AdventureWorksMF_ValueBased]