@NAME

Passes the enclosed string, or list of member or dimension names, as a list of strings to another function.

Syntax

@NAME (mbrName)

Parameter	Description
mbrName	A list of member names, dimension names, or strings.

Notes

Essbase does not support strings in functions. It treats strings as values or an array of values. The @NAME function processes strings.

Example

Example 1

The following example is based on the Sample Basic database. A user-defined function is used to retrieve the price from the table below. The user defined function (J_GetPrice) takes two string parameters, time and product name, to return the price for each product.

MonthName	ProductId	Price
Jan	100-10	1.90
Feb	100-10	1.95
Mar	100-10	1.98
Jan	100-20	1.95
Feb	100-20	2.00
Mar	100-20	2.05

Price = @J_GetPrice(@NAME(@CURRMBR(Product)),@NAME(@CURRMBR(Year)));

The following report illustrates the above example:

               Price   Actual  Market
                Jan     Feb     Mar
                ===     ===     ===
      100-10   1.90    1.95    1.98
      100-20   1.95    2.00    2.05

Example 2

The following example is based on the Sample Basic database:

"Profit Per Ounce" = Profit/@ATTRIBUTEVAL(@NAME(Ounces));

The @NAME function processes the string “Ounces” before passing it to the @ATTRIBUTEVAL function. This example produces the following report:

              Actual      Year      West           
              Profit        Profit Per Ounce
             ========       ================
Cola          4593            382.75