Performs wildcard member selections.
@MATCH (mbrName|genName|levName, "pattern")
mbrName | The default or user-defined name of the member on which to base the search. Analytic Services searches the member names and alias names of the specified member and its descendants. |
genName | The default or user-defined name of the generation to search. Analytic Services searches all member names and member alias names in the generation. |
levName | The default or user-defined name of the level to search. Analytic Services searches all member names and member alias names in the level. |
"pattern" | The character pattern to search for, including a wildcard character
(* or ? ).
To include spaces in the character pattern, enclose the pattern in double quotation marks (""). |
This function performs a trailing-wildcard member selection. Analytic Services searches for member names and alias names that match the pattern you specify and returns the member and alias names it finds.
If the members names in the database you are searching are case-sensitive, the search is case-sensitive. Otherwise, the search is not case-sensitive. To define database member names as case-sensitive, use Outline Editor in Administration Services. See Administration Services Online Help.
You can use more than one @MATCH function in a calculation script.
If Analytic Services does not find any members that match the chosen character pattern, it returns no member names and continues with the other calculation commands in the calculation script.
In the Sample Basic database:
@MATCH(Product,"???-10")
Returns 100-10, 200-10, 300-10, and 400-10
@MATCH(Year,"J*")
Returns Jan, Jun, Jul
@MATCH(Product,"C*")
Returns 100 (Colas), 100-10 (Cola), 100-30 (Caffeine Free Cola), 300 (Cream Soda)
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |