HP Neoview Release 2.5 Software - Manual (Page 235)

Link and Drill Down
Link Reports in Metric Miner
Suppose you have a series of reports, and some of them require input parameters. And suppose
various column values from one report can serve as the input parameters for another report.
Using Metric Miner, you can link the reports. Linking makes it possible to double-click a row
(or right-click a row and select Drill Down) in one report and pass one or more values from
selected columns in that row to another report.
Drill-down capability saves you the trouble of having to load and run many SQL statements
with different input parameters. It also makes it possible to quickly see the effects of different
input values on a report.
You can link reports as part of report configuration, or you can link them as part of drill down.
To link reports:
1. Display (open the tab for) the calling report. This is the report whose result data will be
passed to the called report. For more information about displaying a report, see
“Display
and Run a Saved Report” (page 232) .
2. Use these steps to display the Link Reports dialog box so that you can create report
mappings:
a. Click the button to save the report configuration ( ). The Report Configuration dialog
box appears.
b. Click the Drill Down Attributes tab.
c. Click [ Add ].
TIP: Another way to display the Link Reports dialog box is to double-click a row in the
Report Results Pane or right-click a row and select Drill Down. The Select Report dialog
box appears. Click [ Add ].
3. In the Link Reports dialog box, select a report in the Drill down to Report list. If the report
has input parameters, the input parameters appear in the Map Columns list at the bottom
of the dialog box.
4. Under the Column Name column, click the down arrow and select a table column to map
to each input parameter.
5. Optional: In the Link Reason box, type a reason for the association between the reports.
6. Click [ OK ] to close the Link Reports dialog box.
7. In the Report Configuration dialog box, click [ Save ].
8. Test the link by drilling down on a row in the calling report. See “Drill Down Through
Linked Reports in Metric Miner” (page 236) .
Related Topics
“Add Parameters to Statements” (page 226)
“Drill Down Through Linked Reports in Metric Miner” (page 236)
“Use the Link Reports Dialog Box” (page 236)
Link and Drill Down 235