Use the Select Expert tool to create a more focused SEM report
The Select Expert tool lets you execute queries to create a smaller, more focused report from a larger text-based report.
You can use this tool when you are viewing the text-based view of a report in the Preview frame. You cannot use this tool with the default graphical view displayed when you first run the report.
To View the text-based details of a report, check that the View tab is open and click the tree button to open the subtopics in the reports list. Click the content-based subtopic to jump to that section of the report.
If using the Select Expert to filter report data by date or time fields (such as
DetectionTime) results in an error, clear the error prompt, return to the Select Expert, and delete the time-based filter. To filter by time and date, you must run the report with the specified range.
View the text-based details of a report
In the View tab, click the tree button to open the subtopics in the reports list. Click the content-based subtopic to jump to that section of the report.
Run a report query using the Select Expert tool
Run a report. See Run an on-demand report in the SEM reports application for help.
The report opens on the View tab.
On the View tab, locate the View group, and then click Select Expert.
Click either the New button or the <New> tab.
The Fields form appears with the various report fields you can query on this report.
Click Browse to display a list of available fields you can select with the tool.
Select the field you want to query, and then click OK.
The Select Expert form appears.
The first tab displays your selected field name. It lists the query options for that field and includes an adjacent list where you can select a specific value.
From the left drop-down list, select a query option for the field.
From the adjacent drop-down list, select a specific value for the field.
You can click Browse Data to view a complete list of values in the report for that field. From the Browse Data box, you can select a value, and then click Close to apply that value to the query.
Repeat Steps 3 – 6 for each field you want to add to the query.
To close the form and apply the query, click OK.
The new report appears in the Preview frame.
You can use the Preview frame’s toolbar to save or export the report.
Restore the original report after using the Select Expert tool
When you are through querying a report with the Select Expert tool, you can restore the report to its original state.
To turn off the Select Expert settings: