String Functions

coalesces an empty cell value to a number or string and returns the coalesced value.

CoalesceEmpty(<String Expression>[,<String Expression>]...)

returns a concatenated string that is created by evaluating a string expression over a set.

Generate(<Set>,<String Expression>[,Delimiter>])

returns one of two numeric or string values that are determined by a logical test.

IIf(<Logical Expression>,<String Expression1>,
<String Expression2>)

Note:   If a numeric value is returned, then it is a numeric function, not a string function.  

returns a string in Multidimensional Expressions (MDX) format from a member.

MemberToStr(<Member>)

returns the name of a level, dimension, member, or hierarchy.

<Level>.Name

<Dimension>.Name

<Member>.Name

<Hierarchy>.Name

returns a string that contains a member property value.

<Member>.Properties(Caption)

<Member>.Properties(Name)

<Member>.Properties(UniqueName)

<Member>.Properties(<String Expression>,<TRUE | FALSE>)

Note:    The raw data associated with the property can be either numeric or character, depending on the property type. If the parameter is set to TRUE, then the function returns the raw value for the property instead of the formatted value. If the parameter is set to FALSE, then the function returns the formatted string property. The default value is FALSE.   

returns a string that contains the formatted output based on a SAS format.

Put(<Numeric Expression>,<String Expression>)

Put(<String Expression>,<String Expression>)

constructs a string in Multidimensional Expressions (MDX) format from a set.

SetToStr(<Set>)

returns a string in Multidimensional Expressions (MDX) format from a specified tuple.

TupleToStr(<Tuple>)

returns the unique name of a specified level, dimension, member, or hierarchy.

<Level>.UniqueName

<Dimension>.UniqueName

<Member>.UniqueName

<Hierarchy>.UniqueName

returns the domain name and user name of the current connection.

UserName

returns the caption of the member. It is in non-standard MDX format.

returns the caption of the member. It is in non-standard MDX format.

returns the caption of the member. It is in non-standard MDX format.

returns the caption of the member. It is in non-standard MDX format.

returns the caption of the member. It is in non-standard MDX format.