@CONCATENATE

Returns one character string that is the result of appending one character string (String2) to the end of another character string (String1).

The @CONCATENATE function can be nested to concatenate more than two strings (See Example 2 (@CONCATENATE)).

Syntax

@CONCATENATE (String1, String2)
ParameterDescription

String1

A string or a function that returns a string

String2

A string or a function that returns a string

Notes

  • To use a member name as a character string, use @NAME with the member name.

  • To use the resulting character string as a member name, use @MEMBER with the @CONCATENATE statement; for example,

    @MEMBER(@CONCATENATE("2000_", QTR1));

Example

The following examples are based on the Sample Basic database:

Example 1 (@CONCATENATE)

The following function statement puts the string Item in front of the name of the member currently being processed in the Product dimension; for example, if the current member being calculated is 100-10, the result is Item100-10:

@CONCATENATE("Item",@NAME(@CURRMBR(Product)))

Example 2 (@CONCATENATE)

To concatenate more than two strings, you can nest multiple instances of the @CONCATENATE function. The following function statement returns string values starting with the current member of the Year dimension, followed by an underscore, followed by the current member of the Measures dimension; for example, if the current members being calculated are Qtr1 and Sales, the result is Qtr1_Sales:

@CONCATENATE(@NAME(@CURRMBR(Year)),@CONCATENATE("_",@NAME(@CURRMBR(Measures))))

See Also