@BETWEEN

Returns a member set of all members whose name string value fall between, and are inclusive of, the two specified string tokens. Member names are evaluated alphanumerically.

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

Syntax

@BETWEEN (firstToken , secondToken, topMbrInHierarchy)
ParameterDescription

firstToken

First token string value with which to compare to members in the outline, starting with the member specified in topMbr.

secondToken

Second token string value with which to compare to members in the outline, starting with the member specified in topMbr.

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, @BETWEEN("200-10","200-20", "").

Example

The following example is 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
@BETWEEN(“200-10”, “200-20”, “Product”)

Returns the members [200].[200-10], [200].[200-20], [Diet].[200-10], and [Bottle].[200-10].

See Also