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.