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
See Also