SLD [ Intro | Pubs | WebTables | Workbook | Software | SLACVX | Search ]
[ WebTables : Help | Maintenance ]

Back to Help on the WebTables System

Using the Simple Interface to Plots and Tables

The Simple Interface to Plots and Tables allows easy access to the most commonly used plots and tables. To use it, observe the following three steps (you can actually perform a sample query from this help file):

Step 1: Select Data Types

The available data names are shown on the left side of the table. For example,
Grouped by Day of
Report Date
vs Report
Report Time
Estimated Hours to Fix
Beam Lost Hours
click on the data name to see a detailed explanation of that element.

For the data name that you want, check one of the boxes in the next five columns. In our example, those options are:

The plotting system currently only allows you to plot one quantity at a time. For tables or sum and average, you may select more than one data name.

For some data names, not all columns will be allowed. For example, since Urgency is a character string, it can be shown in tables but it cannot be summed or shown on plots.

Some data names may refer to various output files on disk rather than to Oracle data. An example is the PASS1 Statistics in the SLD Interface. When these data names are included in a table, a column of output file names is presented.

Step 2: Select a Range

Range options are presented as follows:
Last Report Date Report

Step 3: Select How to Handle Invalid Data

Care must be taken to decide how you want invalid elements to be handled. In some cases, you may want to exclude rows of data for which any of the requested elements was invalid. This is particularly important when comparing data between several different columns, or when studying ratios.

Options on how to handle invalid data are presented as follows:

Oracle rows for which some of the requested data is invalid should be Included Excluded

For most data names, data is tagged as invalid if the corresponding entry in the Oracle database is NULL.

A few special data names use other algorithms to determine whether the data should be considered invalid. See the relevant glossary entry (by clicking on the relevant column of the table header) to learn more about these special data names.

Step 4: Submit the Request

Once you have selected data names, range, and how to handle invalid data, you submit the request by hitting one of the five buttons above the columns where you have selected your data.
Grouped by Day of
Report Date
vs Report

Tables Using Group By

If you specify a "group by" element for a table, all rows that have the same value of the "group by" element will be combined.

Joseph Perl and The Run Information Group
Last Updated: 10 July 1997