StrToMbr

The MDX StrToMbr function for Essbase converts a string to a member name.

Syntax

StrToMbr ( string [, dimension ] [, MEMBER_NAMEONLY | alias_table_name ] )

Parameters

string

Input string.

dimension

Optional dimension specification. If used, only member names found in this dimension will be returned.

MEMBER_NAMEONLY

Optional. Create member name only out of member names found (not including aliases). The default is to search for member names and all aliases.

alias_table_name

Optional. Create member name only out of alias name strings found. The default is to search for member names and all aliases.

Notes

You can also use member properties as string input. These properties include MEMBER_NAME, MEMBER_UNIQUE_NAME, MEMBER_ALIAS, ANCESTOR_NAMES, and COMMENTS. For example:

SELECT {StrToMbr(Sales.MEMBER_NAME)} ON COLUMNS
FROM Sample.Basic

Example

SELECT
 { StrToMbr("CA" , [Geography], "Default") } 
ON COLUMNS,
 Children([High End Merchandise]) 
ON ROWS
FROM Asosamp.Basic

returns CA.

SELECT
 { StrToMbr("Quarter1" , [Year], MEMBER_NAMEONLY) } 
 DIMENSION PROPERTIES [YEAR].[MEMBER_ALIAS] 
ON COLUMNS,
 Children([100]) 
ON ROWS
FROM Sample.Basic

returns nothing, because "Quarter1" is an alias.

SELECT
 { StrToMbr("Qtr1" , [Year], MEMBER_NAMEONLY) } 
 DIMENSION PROPERTIES [YEAR].[MEMBER_ALIAS] 
ON COLUMNS,
 Children([100]) 
ON ROWS
FROM Sample.Basic

returns Qtr1.

SELECT
 { StrToMbr("Quarter1" , [Year], "Long Names") } 
 DIMENSION PROPERTIES [YEAR].[MEMBER_ALIAS] 
ON COLUMNS,
 Children([100]) 
ON ROWS
FROM Sample.Basic

returns Qtr1 because "Quarter1" is in the "Long Names" alias table.