@BETWEEN
The @BETWEEN calculation function for Essbase returns member names between two strings.
This function 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)
Parameters
- 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].