To remove the filter, right-click it and select Remove from the menu

Query filter and prompt operators Equal To operator

Use the Equal to operator to obtain data equal to a value.

For example, to return data for the US only, create the filter "County Equal To US".

Not Equal To operator

Use the Not Equal To operator to obtain data not equal to a value.

For example, to return data for all countries except the US create the filter

"County Not Equal To US".

Different From operator

Use the Different From operator to retrieve data different from a value.

For example, to retrieve data for all quarters execpt Q4, create the filter [Quarter] Different From "Q4"

Greater Than operator

Use the Greater Than operator to retrieve data greater than a value.

For example, to retrieve data for customers aged over 60, create the filter

"[Customer Age] Greater than 60".

Greater Than Or Equal To operator

Use the Greater Than Or Equal To operator to retrieve data greater than or equal to a value.

For example, to retrieve data for revenue starting from $1.5M, create the filter "[Revenue] Greater than or equal to 1000500".

Less Than operator

Use the Less Than operator to retrieve data lower than a value.

Working with queries in Web Intelligence Rich Client

9

For example, to retrieve data for exam grades lower than 40, create the filter

"[Exam Grade] Less Than 40".

Less Than Or Equal To operator

Use the Less Than Or Equal To operator to retrieve data less than or equal to a value.

For example, to retrieve data for customers whose age is 30 or less, create the filter "[Age] Less Than Or Equal To 30".

Between operator

Use the Between operator to retrieve data between and including two values.

For example, to retrieve data for weeks starting at week 25 and finishing at 36 (including week 25 and week 36), create the filter "[Week] Between 25 and 36".

Not Between operator

Use the Not Between operator to retrieve data outside the range of two values.

For example; to retrieve data for all the weeks of the year, except for and not including weeks 25 through 36, create the filter "[Week] Not between 25 and 36".

In List operator

Use the In List operator to retrieve data corresponding to values in a list of values.

For example, to retrieve data for the US, UK and Japan only, create the filter [Country] In List ("US";"UK";"Japan").

Not In List operator

Use the Not In List operator to retrieve data that does not correspond to multiple values.

For example, if you do not want to retrieve data for the US, UK and Japan, create the filter [Country] Not In ("US";"UK";"Japan").

9

Working with queries in Web Intelligence Rich Client Filtering queries

Matches Pattern operator

Use the Matches Pattern operator to retrieve data that includes a specific string or part of a string.

For example, to retrieve customers whose date of birth is 1972, create the filter [DOB] Matches Pattern "72".

Different From Pattern operator

Use the Different From Pattern operator to return data that doesn't include a specific string.

For example, to retrieve customers whose date of birth is not 1972, create the filter [DOB] Different From Pattern '72'.

Both operator

Use the Both operator to retrieve data that corresponds to two values.

For example, to retrieve customers who have both a fixed and a mobile telephone, create the filter [Account Type] Both 'Fixed' And 'Mobile'.

Except operator

Use the Except operator to retrieve data that corresponds to one value and excludes another.

For example, to retrieve customers who have a fixed telephone and do not have a mobile telephone, create the filter [Account Type] 'Fixed' Except 'Mobile'.

The Except operator is more restrictive thanDifferent FromorNot In List. For example, a report that returns customers and that includes the filter[Lines] Different From 'Accessories'excludes all sales records where the item sold is part of the 'Accessories' line. If the same customer has purchased Accessories and non-Accessories items, the customer still appears in the report, but their spending total includes only non-Accessories sales.

If the filter is[Lines] Except 'Accessories',only customers who have bought no accessories are included in the report.

Related Topics

• Not In List operatoron page 225

Working with queries in Web Intelligence Rich Client

9

• Different From operatoron page 224

Combining query filters Combining query filters

Typical business questions require you to retrieve information that matches more than one criteria. For example, if you are analyzing customer services data, you will most likely want to focus on customers for a specific time period and also for a specific region, and probably also for a specific level of customer service contract. You can retrieve data that answers several criteria like this by combining filters in the same query.

Example:Analyze sales revenue this year at stores where the floor size is over 4,000 square feet and sales revenue figures are equal to or less than $1.5M

In this example, you are an operations manager for a retail chain. You want to analyze information about the large retail stores in your chain that are making less than the sales revenue figure your company has set as the target.

To do this you add a predefined filter on the [Year] dimension to specify that you only want to retrieve values for this year. Then you create a second filter on the [Sales Floor Size] dimension to specify that you only want to retrieve data for stores where the floor size is greater than 4,000 square feet. After this, you create a third filter on the [Sales Revenue] measure to specify that you only want to retrieve data for stores where the sales revenue figures are equal to or less than $1.5M. Finally, you combine these three filters with the And operator:

Last Year

AND Sales Floor Size Group Greater than or equal to:

4000

Sales Revenue Less than 1,500,000

When you run the query, only data for stores that satisfy all three criteria will be returned to the report.

9

Working with queries in Web Intelligence Rich Client Filtering queries

To combine query filters