Creating a filter
To create a filter, define a condition, specifying which data to display in your cross tab. A filter condition is an If expression that must evaluate to true for data to be included in the cross tab. Examples of filter conditions are:
*
*
*
*
When you create a filter, the available options differ, depending on the following choices:
*
*
For example, if you select Greater Than, you provide one value to which to compare a data value. If you select Between, you provide two values for the comparison. If you select Any Of, you provide one or more values for the comparison.
For more information about comparison operators, see Operators supported in conditional formatting and filter condition expressions.
Figure 5-1 shows an example of a filter condition to apply to a revenue value, a measure. When defining this filter condition, you can break it down into the following parts, as shown in Figure 5-1:
Figure 5-1  
*
*
*
*
*
The cross tab displays revenue values greater than $30,000, as shown in Figure 5-2.
Figure 5-2  
Figure 5-3 shows an example of a filter condition to compare revenue values in the Spain row to revenue values in the UK row. When defining a filter condition, you break it down into the following parts, as shown in Figure 5-3:
*
*
*
*
Alternatively, selecting Absolute Value supports providing a comparison value in the following field.
*
Figure 5-3  
The cross tab displays the revenue value in the Japan row that is greater than or equal to revenues in the UK row. Also, the filters pane displays the applied filters, as shown in Figure 5-4.
Figure 5-4  
Also, you can create a filter that applies to an attribute or dimension, which does not appear in the cross tab preview pane. For example, apply a filter to an attribute or dimension that appears in the cube data, and which narrows the scope of the data that appears in the cross tab. Figure 5-5 shows a cross tab in which the following filter applies to the cube data:
dimension["SalesDate"]["Year"] Equal to 2004
The cross tab filters revenue values and displays those values for only the year 2004. The date dimension does not appear in the cross tab preview pane.
Figure 5-5  
To create each filter, you define a filter condition. You can create multiple filters to display relevant data. Each filter you add further narrows the scope of data displayed. For example, you can create a filter that returns data where the customer’s credit rank is either A or B and another filter that returns open orders between $250,000 and $500,000. Each additional filter introduces complexity to the cross tab. Make sure you design and test multiple filters carefully. If you have too many filters that narrow the scope of the cross tab, no data appears in the cross tab.
For more information about comparison operators to use when you create filter condition expressions, see Operators supported in conditional formatting and filter condition expressions.
How to create a filter that uses a cross tab value
You can use this procedure to create a filter that uses an attribute, dimension, or measure value that appears in the cross tab preview pane.
1  
2  
*
*
*
3  
In Filter, from the list shown in Figure 5-6, select the comparison test, or operator, to apply to the attribute, dimension, or measure. Depending on the comparison operator you select, Filter displays either one or two additional fields or a completed filter condition.
Figure 5-6  
4  
*
Figure 5-7  
*
Choose Select Values to select from a list of existing data values. Figure 5-8 shows how you can select product line values from a list. When they are available, use the previous and next buttons to display more values.
Figure 5-8  
*
Choose List Values to select from a list of existing data values. Figure 5-9 shows how you can select country values from a list for the In operator. When they are available, use the previous and next buttons to display more values.
Figure 5-9  
5  
Choose OK to apply the filter. If the cross tab contains no data that matches the filter condition, the cross tab does not display any data.
How to create a filter that does not use a cross tab value
You can use this procedure to create a filter that uses an attribute or dimension value that does not appear in the cross tab preview pane.
1  
Figure 5-10  
2  
Figure 5-11  
Depending on the comparison operator you select, Filter displays either one or two additional fields or a completed filter condition.
3  
*
Figure 5-12  
*
Choose Select Values to select one value from a list of existing data values. Figure 5-13 shows how you can select a Year value from a list. If they are available, you can use the previous and next buttons to display more values.
Figure 5-13  
*
Choose List Values to select one or more values from a list. For example, the In operator supports selecting multiple values. Figure 5-14 shows selecting two Year values for the In operator. If they are available, use the previous and next buttons to display more values.
Figure 5-14  
Choose OK to apply the filter. If the cross tab contains no data that matches the filter condition, the cross tab does not display any data.

Additional Links:

© Copyright OpenText Corp. All rights reserved. Privacy Policy | Cookie Policy

BIRT iHub 2