@MEMBER

The @MEMBER calculation function for Essbase returns the member with the name that is provided as a character string.

Syntax

@MEMBER (String)

Parameters

String: A string (enclosed in double quotation marks) or a function that returns a string

Example

Typically, @MEMBER is used in combination with string functions that are used to manipulate character strings to form the name of a member. In the following example, the member name QTR1 is appended to the character string 2000_ to form the string 2000_QTR1. @MEMBER returns the member 2000_QTR1 and QTD is set to the value of this member.

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