IBM Tivoli Netcool Performance Manager for Wireless 9.1.2 IBM Tivoli Netcool Performance Manager for Wireless 9.1.2 Adding attribute filters to a report definition IBM Tivoli Netcool® Performance Manager for Wireless 9.1.2 Adding attribute filters to a report definition Assumptions Assumptions Before attempting this IEA, you should already be able to use Using IBM Tivoli Netcool Performance Manager for Wireless 9.1.2 software, know how to: Create a basic report definition Open a report result Use the multiple sort option in the HTML report viewer If you can not perform the above tasks, you can learn how to do them by taking an IBM Tivoli Netcool Performance Manager for Wireless 9.1.2 User course: http://www.ibm.com/software/tivoli/education/edu_prd.html#X916845N81075L22 Assumptions You should already know the following before attempting this IEA: Using IBM Tivoli Netcool Performance Manager for Wireless 9.1.2 software, know how to: Create a basic report definition Open a report result Use the multiple sort option in the HTML report viewer If you can not perform the above tasks, you can learn how to do them by taking the IBM Tivoli Netcool Performance Manager for Wireless 9.1.2 User course Objectives Objectives Upon completion of this module, you should be able to: Modify an existing report definition with attribute filtering Filter report output data to focus on either a single network element or a group of network elements Use logical operators and the Value Filter to insert network elements into the Add Filters section Upon completion of this module, you should be able to: Modify an existing report definition with attribute filtering. Filter report output data to focus on either a single network element or a group of network elements. Use logical operators and the Value Filter to insert network elements into the Add Filters section. Adding attribute filters to an existing report definition Adding attribute filters to an existing report definition Attributes filters allow PMW users to focus network report results on either a group of network elements or an individual network element. This example report provides data on all cells in a network. Adding attribute filters can exclude unwanted cells from the report output. Reports run with attribute filters provide output data only for the network elements listed in the attribute filter section. Prerequisites to adding an attribute filter Prerequisites to adding an attribute filter To create an attribute filter for an existing report definition the desired original report must first be selected and loaded. To accomplish this prerequisite first left-click the Reporting heading and then left-click the manage report subheading. Selecting the report definition Selecting the report definition Select the desired existing report definition from the drop-down menu options. Click onto the desired report name found within the lower box, then click the open button. Modifying the report definition Modifying the report definition At this point steps 1 through 4 will be filled with the report definition data from the existing report. Adding attribute filters to a report definition Adding attribute filters to a report definition To add an attribute filter to the existing report definition make sure that all of the mandatory report parameters are properly completed in steps 1 through 4 of your report definition. Next, click the edit button found to the far right within the Step 5: Filtering section. Setting up attribute filter options Setting up attribute filter options Under Attribute Filters select the report definitions focal entity. In this report the focal entity is Cell. To filter report output to exclude all but a single cell you use the cell’s identifier attribute entity, Cell_Id, from the second drop-down menu. Next, click the more button found over to the far right. To create a similar filter for multiple cells that report to the same base station you can use the base station identifier, BS_Id. Adding the attribute filter Adding the attribute filter As the cell IDs appear in the add|delete section highlight the cell you are interested in and click the add button. In the example the cell 1-1-1-1 is selected. Adding the attribute filter Adding the attribute filter Cell_Id 1-1-1-1 is now in the lower box. Highlighting Cell_Id 1-1-1-1 again and clicking the lowest add button completes modifying the report definition to focus on presenting only Cell_Id 1-1-1-1 output data. Added filters Added filters Cell.Cell_Id 1-1-1-1 has been added to the Added Filters list. Checking the box is required only if it is desired to delete the added filter. Reports focus output results on any items listed in the Added Filters section. Once the Added Filters section is filled the resulting report will only show data for the listed network elements. In the example the report output will only present data for the cell with an ID of 1-1-1-1. Running the revised report Running the revised report Now scroll to the bottom of the PMW screen and click run. Report setup Report setup At this point the entire report setup can be seen on the left which includes the Step 5: Filtering for Cell.Cell_Id 1-1-1-1. Press the run report & wait button located in the right column to get the report output data. Filtered report output Filtered report output After running the revised report with the selected attribute filter the report displays the data for Cell.Cell_Id 1-1-1-1. Using logical operators in attribute filtering Using logical operators in attribute filtering The PMW client GUI screen offers seven types of logical operators: equals, does not equal, greater than, greater than or equal, less than, less than or equal, and contains. These logical operators are used to filter report data output to exclude all but either a single network element or a specific group of network elements. Using logical operators in attribute filtering Using logical operators in attribute filtering The specific network element types that logical operations are performed on is selected by the PMW user from choices revealed within the attribute entities drop-down menu. Using the equals logical operator Using the equals logical operator Equals is used when the PMW user wants to focus report output on presenting data pertaining to a single network element as opposed to a group of network elements. Using the equals logical operator: Selecting the attribute entity Using the equals logical operator: Selecting the attribute entity In this example we filter for attribute entity Cell_Id 1-1-1-1 with the equals logical operator. This will program the report definition to exclude data pertaining to all other network elements types. We further filter for output data presentation only related to network element Cell_Id 1-1-1-1. Using the equals logical operator: Adding the filter Using the equals logical operator: Adding the filter Upon clicking the add button Cell_Id 1-1-1-1 is moved to the Added Filters box. Using the equals logical operator: Generating the report Using the equals logical operator: Generating the report With the report definition attribute filtering set for Cell_Id 1-1-1-1 we scroll to the bottom of the PMW client GUI screen and click the run button to start report generation. Using the equals logical operator: Run choices Using the equals logical operator: Run choices After pressing the run button on the previous screen we see that Step 5: Filtering in the lower left column has Cell_Id 1-1-1-1 listed as an Attribute Filter. This instructs PMW to run the report and to only output data for network element Cell_Id 1-1-1-1. In the lower part of the right column we can either click to run report & wait, run report in background, or cancel the report run. Using the contains logical operator Using the contains logical operator In this example we will demonstrate using the contains logical operator. The contains logical operator is always utilized when the PMW user wants to add more than one network element to the report definition. Using the contains logical operator: Selecting network elements Using the contains logical operator: Selecting network elements In this example we filter for Cell_Id names 1-1-1-1 and 1-1-1-2. We use a comma and a space to separate the two network element entries. Using the contains logical operator:moving IDs to add filters box Using the contains logical operator: moving IDs to add filters box Then click on the add button to move the desired Cell_Ids to the Add Filters box. Using the contains logical operator:generating report Using the contains logical operator: generating report With the report definition attribute filtering set for Cell_Id 1-1-1-1 and Cell_Id 1-1-1-2 we scroll to the bottom of the PMW client GUI screen and click on run to start report generation. Using the contains logical operator:Run choices Using the contains logical operator: Run choices Now we can see that Step 5: Filtering in the lower left column has Cell_Id 1-1-1-1 and 1-1-1-2 listed as Attribute Filters. In the lower box of the right column we can either click to run report & wait, run report in background, or cancel the report run. Using the value filter Using the value filter The Value Filter is used to limit the number of elements displayed. First the asterisk (*) wildcard value is entered in the Value Filter box. Next the apply button is clicked. The combination of settings produces a list of all Cell_Id network elements. Using the value filter: Modifications Using the value filter: Modifications In this example modification is made. First entry of Cell_Id 1-1-1-3 is made into the Value Filter box. Next click the apply button. We then see that all Cell_Id names are eliminated except for Cell_Id 1-1-1-3. Now we can use the add buttons to drop Cell_Id 1-1-1-3 to the Added Filters area. Using the value filter: Add process Using the value filter: Add process Highlight Cell_Id 1-1-1-3 and click the add button. Using the value filter: Added filters Using the value filter: Added filters Cell_Id 1-1-1-3 is now dropped to the lower box. Using the value filter: Confirming addition Using the value filter: Confirming addition First, highlight Cell_Id 1-1-1-3 in the lower box. Next, click the lower add button. Using the value filter: Summary Using the value filter: Summary To summarize we used Value Filter to select Cell_Id 1-1-1-3 from a list of available Cell_Id network elements. Then we dropped Cell_Id 1-1-1-3 to the Added Filters section. Using the value filter: Wildcard example Using the value filter: Wildcard example This example shows another use of Value Filter. The Value Filter has a wildcard asterisk (*) option that allows the PMW user to make multiple network elements available for selection. Here we enter the character string 2- with the asterisk. Next, click the apply button. Using the value filter: Elements displayed Using the value filter: Elements displayed After clicking on the apply button the lower box reveals all of the Cell Id network elements that start with 2. Using the value filter: Selecting multiple elements Using the value filter: Selecting multiple elements Now you can select two of the listed Cell Id network elements by holding down the Ctrl key while clicking to select them. Using value filter: Moving selected IDs Using value filter: Moving selected IDs After clicking on the upper add button Cell_Id 2-3-1-1 and Cell_Id 2-3-1-2 are moved to the lower box. Using the value filter: Setting logical operator Using the value filter: Setting logical operator If more than one network element is desired for report output we must change the logical operator to contains. Using the value filter: Using contains Using the value filter: Using contains Here we have changed the logical operator from equals to contains. In order to select more than one network element for report output filtering the logical operator box must be set to contains Using the value filter: Confirmation Using the value filter: Confirmation Again hold down the Ctrl key and click to highlight the two desired Cell_Id network elements. Next click the lower add button. Using the value filter: Moving to added filters Using the value filter: Moving to added filters After clicking the lower add button the two desired Cell_Ids are moved to the Added Filters section. When the report is run it will only give output data pertaining to Cell_Id 2-3-1-1 and Cell_Id 2-3-1-2. Summary Summary You should now be able to: Modify an existing report definition with attribute filtering Filter report output data to focus on either a single network element or a small group of network elements Use logical operators and the Value Filter to insert the network elements into the Add Filters section You should now be able to: Modify an existing report definition with attribute filtering. Filter report output data to focus on either a single network element or a small group of network elements. Use logical operators and the Value Filter to insert the network elements into the Add Filters section Training roadmap for IBM Tivoli Netcool Performance Manager for Wireless Training roadmap for IBM Tivoli Netcool Performance Manager for Wireless Click this link to the training page http://www-01.ibm.com/software/tivoli/education/edu_prd.html Click this link for the section on IBM Tivoli Netcool Performance Manager for Wireless: http://www.ibm.com/software/tivoli/education/edu_prd.html#X916845N81075L22 Training roadmap for IBM Tivoli Netcool Performance Manager for Wireless Click this link to the training pagehttp://www-01.ibm.com/software/tivoli/education/edu_prd.htmlClick this link for the section onIBM Tivoli Netcool Performance Manager for Wireless Trademarks