Working with filters

To use filter options

1. In the Categories field, select a category.
   The Metrics field displays all the selected metrics from the current category, while also showing the count of Advanced metrics that you have selected along with the total. You can select or unselect metrics from this list. 
   

   When you select a category, the filter bar displays filters specific to that category. When you change the category, one or more filters on the filter bar might change. Some of the filters are as follows:

   • Sysplex
   • CPC Name
   • SMF ID
   • System Name
2. To display the advanced metrics in the list, select Show Advanced Metrics in the Metrics field.
   If you have selected an advanced metric for a category, it is displayed next to the metric name. The selected advanced metrics are always sorted alphabetically after the basic metrics.
   The metric field also displays the number of available advanced metrics for that category. 
   A metric with  next to it indicates that the metric is currently used for the top or bottom N ranking option on the chart. The filter selections work from left to right. Changing an object in a filter invalidates all filter selections that are on the right. This change can be made in the Advanced Filter Options panel.
   A next to a metric indicates that it has an attached alert rule. 
   To sort the metrics, click Sort By next to the search field and select one of the following options:
   • Metric Name: Searches metrics by the name. The list is populated in ascending alphabetical order.

   • Selection: Searches for all selected metrics. When you use this option, the selected metrics are the first in the list followed by selected advanced metrics, unselected basic metrics, and unselected advanced metrics in alphabetical order.

     

     Warning

     Important

     Use filters to reduce the amount of data returned from the query. Selecting ALL in the filters might result in queries returning large amounts of data. 

3. (Optional) Use the search field on the filters bar to displays relevant filters. To search for relevant filters, you can use wildcard characters to search for relevant filters.
   To see the details of the available search wildcards, click . For more information, see To use filter values and wildcard characters in the search field.
   To get the complete list of the filter values, clear all text in the search field.
   

1. (Optional) Select the Aggregate Selections checkbox to aggregate all selections in a filter to a single object, and aggregate all selections in a filter to a single object called aggr.
   When you select the Aggregate Selections checkbox for a given filter, thesymbol indicates that the selections for that filter item are aggregated.

1. Click one of the following options to run a query based on your requirement: 
   
   
   
   • Run Query: Runs the query for the currently selected category only. It does not produce an alert preview.
   • Run Query For All Categories: Available when the report view has more than one category. It does not produce an alert preview.
   • Run Query with Alerts: Available when at least one metric in the selected category has an attached alert rule. The generated alerts are displayed in the Alert Preview.

   • Run Query With Alerts For All Categories: Available when a report view has more than one category and at least one metric with an attached alert rule. The generated alerts are displayed in the Alert Preview.
     For more information about attaching alert rules, see Managing-alerts-for-anomaly-detection.

     Warning

     Important

     If the request returns a large amount of data, the tool displays a warning. You can still proceed with the query though it might take a long time to complete.

     The current report view displays the data.

To use filter values and wildcard characters in the search field

In the filter bar, when you use the filter values and wildcard characters in the search field, the following conditions apply: