TEXT2MBR

Syntax

TEXT2MBR (Dimension, Text)

Description

Converts text to the member with that name in Dimension. If there is no member with that name, returns 0.

Note:

This is essentially a linear lookup function, so be careful when using it with dimensions that have a lot of members.

Example

TEXT2MBR(MONTHS, "January") returns a new member, January, in the MONTHS dimension.