User`s guide
b. To create a new report definition, select File -> New Report Definition.
c. To select the table whose data is to be used in the report definition, select the arrow to the right of the Select Table field,
and then follow this path, starting at All:
CSi
All ->
DAY.CSIMRX
-> OK
OVNV
All
->
DAY.HN2NIX
->
OK
OV
All ->
DAY.HN2NIX
-> OK
d.
To select the variables whose data is to be used in the report definition, select the arrow to the right of the Select
Variable field, and then select Analysis -> IPIDELV Mean -> Add -> X Variable -> HOUR -> Add -> Class ->
UDAY -> Add -> By -> MACHINE -> Add.
Check that you have selected these variables by selecting Show All. You should see:
Variable Variable Type Description
IPIDELV ANALYSIS MEAN: # datagrams delivered/sec
HOUR XVAR Hour
UDAY CLASS FORMULA: Day
MACHINE BY Machine
(If you need to correct the list, select the variable type of the incorrect variable, select the incorrect variable, and select
Remove. Then select the correct variable.)
Select OK to return to the main report definition window.
e. To define which subset of the data is to be used by the report definition, select the arrow that is to the right of the Subset
Data field and then select Query/Where Clause Builder. Using the buttons that are to the left of the Local Query/Where
Clause For This Report field, select Variable -> MACHINE -> OK -> Operator -> IN -> OK -> Value -> with the
Ctrl key pressed, select the servers on which you want to report -> OK.
Select
OK
to return to the main report definition window.
f. To specify the summary time period, select the arrow to the right of the Summary Time Period Field. Then select As Is
-> OK.
g. To specify the report style, select the image in the Current Report Style field. (That is, select the image below the words
Current Report Style.) Then select 3D Graphs -> Pillar -> OK.
h. To run the report definition and generate the report, select Run. You should see a 3D "cityscape," with the Hourly Mean
of the Number of Datagrams delivered per second on the Y axis, the hour of the day on the X axis, and the day of the
week on the Z axis. This report is for the last machine that you specified in the Where Clause. To see the reports for the
other machines, select View -> Backward.
i. To return to the main report definition window, select File -> End.
If you have at least several weeks of data in your PDB, you can also experiment with a variation on this report definition: follow
the same steps but use UWEEK where you used HOUR.
If you find this kind of report useful, you can save reports and report definitions from the main report definition window by
selecting File -> Save Report Definition. in the same way that you did in Section 2, Task 3: Customize Your Report
Definitions.