Substring

The MDX Substring() function for Essbase returns the substring between a starting and ending position. Both the positional arguments are 1-based.

Syntax

Substring ( string, index1 [, index2 +] )

Parameters

string: String to subdivide (or field containing that string).
index1: A number n representing a starting position within a string.
index2: Optional. A number n representing an ending position within a string. If omitted, the endpoint is assumed to be the end of the original string.