1. Calculation and Query Reference for Oracle Essbase
  2. MDX
  3. MDX Function Return Values
  4. MDX Functions that Return a String

MDX Functions that Return a String

The following MDX functions for Essbase are helpful for string processing. NumToStr converts a floating point value to a string. Most of the string functions take a string as input; for example, Concat adds strings together, and LTrim removes whitespace from the left side of a string.

Table 4-33 MDX String Functions

Function Result
FormatDate Formats date strings.
Concat Concatenates input strings.
Left Returns a specified number of characters from the left side of the string.
Right Returns a specified number of characters from the right side of the string.
LTrim Trims whitespace on the left of the string.
RTrim Trims whitespace on the right of the string.
Lower Converts upper-case string to lower case.
Upper Converts lower-case string to upper case.
Substring Returns the substring between a starting and ending position.
NumToStr Converts a double-precision floating-point value into a decimal string.