@CONCATENATE

Returns a character string that is the result of appending one character string to another character string.

Syntax

@CONCATENATE (String1, String2)

String1 A string or a function that returns a string
String2 A string or a function that returns a string

Notes

Description

This function creates a single character string by attaching one character string (String2) to the end of another character string (String1). The resulting string contains the characters from both source strings. The @CONCATENATE function can be nested to concatenate more than two strings (See Example 2).

Examples

The following examples are based on the Sample Basic database:

Example 1

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

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

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com