Operator Types and Data Operators

The OLAPQuery section supports the following operator types and data operators:

OLE DB Operator Types and Data Operators (see Table 44)

Essbase Operator Types and Data Operators (see Table 45)

Note:

Not all providers support all operators.

Table 44. OLAP Query Operator Types and Data Operators

Operator Type	Description
Select Members from DB	Creates a filter based on a member(s) retrieved from the database. (Supported for the Essbase, MSOLAP and SAP/BW databases).
Select by Measure	Creates a filter based on a measure that you specify.
Top N	Retrieves only the top N values where each top N value is at least the specified Index value.
Top N %	Retrieves only the top N % values where each top N % value is at least the specified Index value.
Top Sum	Retrieves the top N (the smallest number possible) values, such that their sum is at least the specified Index value.
Bottom N	Retrieves only the bottom N values where each bottom N value is at least the specified Index value.
Bottom N %	Retrieves the bottom N% where each bottom N % value is at least the specified Index value.
Bottom Sum	Retrieves the bottom N (the smallest number possible) values such that their sum is at least the specified Index value.
Data Operator	Description
= Equal	Retrieves only records where the filtered item equals the specified value(s).
< > Not Equal	Retrieves only records where the filtered item does not equal the specified value(s).
< Less than	Retrieves only records where the filtered item is less than the specified value(s).
< = Less than or Equal to	Retrieves only records where the filtered item is less than the specified value(s).
> Greater than	Retrieves only records where the filtered item is greater than the specified value(s).
> = Greater than or Equal to	Retrieves only records where the filtered item equals, or is greater than the specified value(s).

Table 45. Essbase Operator Types and Data Operators

Operator Type/ Data Operator	Definition
Equal	Retrieves only records where the filtered item equals the specified value(s).
Match Member	The Match Member performs a trailing-wildcard member search for member names and alias names that match the pattern you specify. It returns the member and alias names it finds. The search uses the Essbase formula: mbrName\|genName\|levName, "pattern"). The character pattern to search for, including a wildcard character (* or ?). ? substitutes one occurrence of any character. You can use ? anywhere in the pattern. * substitutes any number of characters. You can use * only at the end of the pattern. To include spaces in the character pattern, enclose the pattern in double quotation marks ("").
Data Operator	Description
= Equal	Retrieves only records where the filtered item equals the specified value(s).
< > Not Equal	Retrieves only records where the filtered item does not equal the specified value(s).
< Less than	Retrieves only records where the filtered item is less than the specified value(s).
< = Less than or Equal to	Retrieves only records where the filtered item is less than the specified value(s).
> Greater than	Retrieves only records where the filtered item is greater than the specified value(s).
> = Greater than or Equal to	Retrieves only records where the filtered item equals, or is greater than the specified value(s).