@LIKE
The @LIKE calculation function for Essbase returns a member set of member names that match the specified pattern.
This function can be used on unique and duplicate-name outlines.
Syntax
@LIKE(pattern, topMbrinHierarchy, [escChar])
Parameters
- pattern
-
The character pattern with which to compare to members in the outline, including a single wildcard character:
-
%
: The percentage sign allows matching to a string of any length (including zero length). -
_
: The underscore allows matching on a single character in a member name.
-
- topMbrinHierarchy
-
A fully qualified member name 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,@LIKE("100%", "")
. - escChar
-
Optional: A one-byte-length escape character to use if the wildcard character exists in member names.
If you do not specify an escape character, a backslash (
\
) is assumed.
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
@LIKE("100%", "Product")
Returns members 100, 100-10, 100-20, and 100-30.
@LIKE("30_", "Product")
Returns member 300.
@LIKE("200\_", "Product", "\")
If member 200 has children named 200_10 (note the underscore,
_
), 200-20 (note the dash,-
), 200_30 and 200-40, returns those members whose name contains an underscore: 200_10 and 200_30.
See Also