Filtering Interactive Reports
Some reports are very long, and may run into several pages. However, not all details represented in the report may interest you. You can filter the report to specifically view the information that you need.
Adding a Filter
After you generate a report, you can filter the contents of the report based on the columns present in the report. To create a filter:
Step 1 Click the Filter icon .
The filter pane opens.
Step 2 From the left navigation pane, from the Data tab, drag and drop the fields (that are already available in the report as columns) to the Apply Filter pane.
The Filter on Field Name appears.
Step 3 From the Filter on Field Name, specify the condition based on which the filter has to be applied. Enter a parameter name that describes the filter name.
To narrow down the filter parameters, and to specify your exact requirement, choose the Select from a List option. For example, if you want to filter the report for a few types of devices, drag the Device Type field, and from the Select from List option, choose the types of devices to be included, and move them to the Currently (Included) pane. The filter is now applied only on the device types specified.
Step 4 Click OK.
Creating Advanced Filters
After you create filters using the steps explained in Adding a Filter, you can customize the filter to exclude and include data in the combination that you set. For example (), from the Virtual Machine State Inventory report, you can set the filter to view report details of one of the following fields: Host Name (with specific name), RAM Size (that you can specify), Host Up Time (specify a period). You can also give an ‘AND’, ‘OR’ operator with a few more conditions that must be filtered with the above-mentioned conditions.
Figure 5-3 Filtering Reports—Example
Perform the following steps to customize the filter for advanced settings:
Step 1 Create a filter as outlined in the section Adding a Filter.
Step 2 From the fields that are listed in the filters pane, create advanced filters by creating a hierarchy. From the down arrow displayed on the filter parameter, choose the position of the parameter. Click Move Up or Move Down , as required.
Step 3 If you prefer a parameter to be an AND operator of another parameter, click the down arrow of the first parameter and choose Indent .
For example, if you want to view report details of Host Name of a specific RAM Size, move the Host Name up, and indent RAM Size. If you desire to view the details of a host with Host Name and Host Up time parameters, move Host Name up and indent Host Connection State.
Step 4 Repeat the procedure for the filters you have chosen.
Step 5 From the master AND, OR operator, choose as required.
For example, if you desire to filter based on both (Host DNS Name and RAM Size) and (Host Name and Host Connection State), choose the AND operator from the drop-down list on its right.
Applying Quick Filters
Prompts are quick filters that are used without adding specific restrictions. You can filter the data based on any data field available on the left navigation pane. However, you cannot specify ‘And’/’Or’ options.
To create a prompt, click the Prompts icon, and drag and drop the fields from the left navigation pane.
For example, if you set the prompt for VM Device State and Number of Devices, you can see the number of devices for a specific VM device state. Prompts are especially useful when you want to add a From and To date before you begin generating customizable prepackaged fault reports.
Note To add a prompt for a range of days (with From and To dates options), drag the Date field twice. This creates two options from which you can select the From and To date.
Upon adding prompts, the report is filtered to reflect the prompts, and a refreshed report appears. If you select the prompt for VM Device State (with the state Suspended selected), the devices whose VM device state is suspended appears.
The structure added in Prompts reflects in the Filter option as well.
You can edit the prompts that you have created for reports. Editing the prompts functionality allows you to choose the methods of selecting prompt options such as radio buttons, check box, or text box. You can also specify the first value that needs to be selected by default. To edit a prompt, follow the procedure below:
Step 1 Select a Prompts. From the data tab, choose the required parameters and drag and drop to the Prompts field.
Step 2 After the data field is added, mouse over on the prompt. A pencil icon appears. Click the pencil icon.
The Prompt for data field window appears.
Step 3 Enter a name for the prompt.
Step 4 Choose a Type of Control; this decides the modality of selection of items in the prompts.
If you choose the control type List, you can specify the number of values that are displayed when you begin choosing the items listed in the Prompts field.
Step 5 Choose a Data Type . The following options are available:
- Metadata List—Select this data to enable the prompts feature to work against a database. If you choose Metadata List, select the Data Source that the report runs against.
- Static List—This option is not supported in Prime Network 4.2 Operations Reports.
Step 6 From the Control Properties pane, choose the options as required:
- Initially Selected—This allows you to specify the value that is selected from the list by default
– Use First Value—By default, selects the first value from the available list
– Specify—Specify the value that should be selected by default when you click Prompt.
Step 7 Click OK .