Passes the enclosed string, or list of member or dimension names, as a list of strings to another function.
@NAME (mbrName [,UNIQUE])
A list of member names, dimension names, or strings.
Tells @NAME to return a unique member name (using shortcut qualified name format) for mbrName, if mbrName is a duplicate name. If mbrName is not a duplicate name or if duplicate member names is not enabled, UNIQUE is ignored, and only the member name is returned.
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.
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
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
For the following example, assume an outline that has duplicate member names enabled, and there are two members named New York in the Market dimension:
The qualified member names for the New York members are [State].[New York] and [City].[New York].
The following example captures a qualified member name from the current calculation context:
If the current member of Market being calculated is the New York State member, the qualified member name, [State].[New York], is passed to the @MEMBER function, effectively differentiating it from the New York City member.