Technical data

Using Built-in Functio ns in Analytic Models Chapter 11

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.

TEXT2NUM

Syntax

TEXT2NUM (Text)

Description

Converts Text to a number. This performs a forgiving conversion. For example, dollar signs and commas are

ignored, parentheses or a minus sign make the number negative, and % causes the number to be converted as a

percentage. If there is no number in the text, the function returns 0.

Example

These example

s employ the TEXT2NUM built-in function:

• TEXT2NUM("TEN") returns 10.

• TEXT2NUM("$TEN") returns 10.

• TEXT2NUM("-TEN") returns -10.

• TEXT2NUM("100,000") returns 100000.

• TEXT2NUM("10%") returns 10%.

THIS

Syntax

THIS(Expression)

Description

The THIS function returns the value of Expression for the members being calculated, eve n if Expression is

used in a database function. This function enables you to perform complex calculations that relate other

members in a dimension to the member being calculated.