Related Topics:
	Risk Priority Numbers (RPNs)

Displaying RPN Metrics in Queries and Reports

Any of the RPN metrics that have been enabled in the project can be used in the queries and reports that you create. For example, if you want to create a report that lists all causes in the FMEA that have an initial RPN greater than 200, do the following:

• Choose Home > Reporting > Queries to open the Query Utility.

• Choose FMEA Causes from the drop-down list at the top of the window.

• In the row for Initial RPN, choose is greater than from the first column under Criterion 1 and then enter 200 in the second column.

• Click Run Query to display the results when the query is applied to the current data. If the table on the Results tab does not exactly meet your needs for the custom report, you can go back to the Criteria tab and use the Include in Results column to hide or display particular fields. You also can click the Headers Customization tab if you want to change the order or widths of the columns.

• Click the Run Query button again to see the effects of your changes. When you are satisfied with the results, click the Save Query icon and provide a name for the query template (e.g., "High Priority Causes").

• Close the Query Utility and then choose Home > Reporting > Reports to open the Reports window.

• When you scan through the list of Available Reports, you can see that your new query template appears under FMEA Records.

• To create a report document that includes the full FMEA spreadsheet and the list of causes with an RPN greater than 200, select one of the options under FMEA Spreadsheet and then double-click the option to add it to the list of selected reports. Do the same for the custom query that you just created.

• In the Select Output Type area in the bottom-left of the window, choose the output type (Word or Excel) and then click Generate Report to create the document.

You can follow a similar procedure to create other types of queries and reports that will display the analysis information in ways that will support the decisions that need to be made.