Working with filters


After you add a category to a report view, you are redirected to the workflow view. The workflow view includes a filter bar. The filter bar contains the categories and metrics that you selected in the Add Category pane. The filter bar displays the filters associated with the selected category and metric.

To use filter options

  1. In the Categories field, select a category.
    The Metrics field displays all the selected metrics from the current category. You can add or delete metrics from this list. 
    For more information about adding categories, see Working-with-reporting-categories.
    BMC AMI Capacity Reporting Filter options

    Warning

    Important

    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

    Selecting the Show Advanced Metrics option in the Metrics field displays the advanced metrics in the list. 
    The filter selections work from left to right. Changing an object in a filter invalidates all filter selections that are on the right.

    image2022-10-27_10-31-54.png

    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. 

  2. (Optional) Use the Search field to restrict the displayed filters.
    You can use wildcard characters. 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.
    image2022-10-27_10-34-2.png

  3. (Optional) Select the Aggregate Selections check box to aggregate all selections in a filter to a single object and produce a single series on the chart.
    When you select the Aggregate Selections check box for a given filter, aimage2022-10-27_10-36-53.pngicon indicates that the selections for that filter item are aggregated.
  1. Click Run Query or Run Query with Alerts.
    The Run Query with Alerts check box is displayed only if you have selected a category that has attached alerts.

    image2022-12-1_20-41-33.png

    • If you select Run Query, the query runs only for the category selected in the filter bar. If there are multiple categories and you have made changes to any of them, click Run Query for each modified category.
    • If you select Run Query with Alerts, the alert processing occurs only for the selected category. If alerts are generated, the Alert Preview window displays the alert information.
      For more information about attaching alert rules, see Managing-alerts.
      image2022-12-1_20-44-28.png


      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: 

Filter values/Wildcard 

Result 

Example

Any value

Exact match

Entering CM returns CM only, but not CM01CM123, and so on.

"*"

Matches any number of characters starting from 0

Entering "CM*" returns a match of CM, CM01, CM123, and so on.

?

Matches exactly one character in the value entered

Entering CM?2 returns a match of CM12, CM22, CM32, and so on.

(Prefix) !

Matches all the strings that do not match values using this prefix.

Entering !CM returns a match of all values except CM.

Entering !CM* returns a match of all values except CM, CM01, CM123, and so on.

Entering !CM?2 returns a match of all values except CM12, CM22, CM32, and so on.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC AMI Capacity Reporting 23.1