Essbase @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)
Parameter Description
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

  • @SUBSTRING
  • @MEMBER
  • @NAME