@EQUAL

Returns a member set of member names that match the specified token name.

This function can be used on unique and duplicate-name outlines.

Syntax

@EQUAL (tokenName, topMbrinHierarchy)
ParameterDescription

tokenName

Token string value, representing the name of a member, with which to compare to members in the outline, starting with member specified in topMbrinHierarchy. The specified token name must not be qualified for duplicate members.

topMbrinHierarchy

A fully qualified name of a member in the outline on which to base the member search. The specified member and its aliases, and all of its descendants, are included in the search.

To search the entire outline, provide an empty string ("") for this parameter. For example, @EQUAL("100-10", "").

Example

The following examples are based on the following duplicate-name outline:

Product
   100
      100–10
         100–10–10
      100–20
      100–30
   200
      200–10
      200–20
      200–30
   300
      300–10
      300–20
   Diet
      100–10
         100–10–11
      200–10
      300–10
   Bottle
      200–10
      300–20
@EQUAL("100-10", "Product")

Returns the members [Diet].[100-10] and [100].[100-10].

@EQUAL("100-10", "Diet")

Returns the member [Diet].[100-10].

See Also