The MDX functions
that are listed here indicate their return type.
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.