1. Scripting Reference for Oracle Essbase
  2. Report Writer
  3. Report Writer Command List
  4. MATCHEX

MATCHEX

Performs wildcard member selection. Essbase searches for member names that match the pattern you specify, and returns the member names it finds.

Provides an optional parameter to specify if the search should be performed on member names or aliases, regardless of whether the query output in the report script uses members or aliases.

If you defined the members names in the database you are searching as case-sensitive, the search is case-sensitive. Otherwise, the search is not case-sensitive.

You can use more than one MATCHEX command in your report.

If Essbase does not find any members that match the chosen character pattern, it returns no member names and continues with the other report commands in your report.

Syntax

<MATCH ("Member"|"Gen"|"Level","Pattern",ALT|MBR|BOTH)

Parameters

"Member"

Member name at the top of the member hierarchy you want to search. Essbase searches the member name and its descendants.

"Gen"

Default or user-defined name of the generation you want to search.

"Level"

Default or user-defined name of the level you want to search.

"Pattern"

The character pattern you want to search for, including a wildcard character (* or ?).

  • ? Substitutes one occurrence of any character; can be placed anywhere in the string.

  • * Substitutes any number of characters; must be used at the end of the string.

  • You can include spaces in the character pattern. Ensure that you enclose the pattern in quotation marks ("").

ALT|MBR|BOTH

Optional—The ALT|MBR|BOTH option overrides default pattern matching specifications. The default pattern matching uses aliases for pattern matching if aliases are to be displayed in report output, but uses names otherwise.

  • ALT

    Filter using aliases of selected members from selected alias table for pattern matching. The alias table is set by outaltselect, otherwise default alias table.

  • MBR

    Filters using member names of selected members for pattern matching.

  • BOTH

    Filters using member names as well as aliases for selected members from selected alias table for pattern matching. The alias table is set by outaltselect, otherwise default alias table.

Example

The following report script example is designed for the Sample Basic cube, available in the gallery.

<OUTALTSELECT default
<MATCHEX(Product,Caff*,ALT)
!
<OUTALTSELECT "Default"
<NewAlt "Product"
<OUTMBRNAME
<LINK(<MATCHEX("Product", "100", MBR) AND <IDESCENDANTS("Product"))
!

This example produces the following report:

      Year Measures Market Scenario 

100-30              1,983 
Colas              30,468