@CONCATENATE

The @CONCATENATE calculation function for Essbase joins two character strings. It returns a character string that is the result of appending one character string to the end of another character string. To concatenate more than two strings, you can nest the function.

Syntax

@CONCATENATE (String1, String2)

Parameters

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 @CONCATENATE; 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))))