Sun Microsystems
Products & Services
 
Support & Training
 
 

Previous Previous     Contents     Index     Next Next

ProcedureHow to Create a View Configuration

Steps
  1. To change the view configuration for a query choose the View tab.

    To create a view for a saved query:

    • choose the query from the Query List on the Overview page

    • press the Edit button

    • click on the View tab.

    The queries current view configuration displays.

  2. Declare how you want to view the results of your query.

    You can add three different sections to the view configuration, decide if additional information about the query is shown, and in which order it is shown.

    view 1 page

    On top there are jumplinks to jump to the corresponding section if it is available. The possible sections are Database Table, Pivot Table and Graphic. The View Configuration section is always visible and allows to switch on the display of the query description that has been entered on the common tab, the filter conditions from the filter list and the resulting SQL statement of the query definition or the content of the SQL tab for advanced queries.

    Pressing Add Database, Add Pivot, Add Graphic adds the corresponding section.

    For some queries, only a subset of the possible view selections are meaningful. For example, if you have only two columns to select from, pivot makes no sense.

    For the Database Table add and choose the columns that you need to display under Name and adjust their Type and Format. The order in which the columns are added will be the order in which the columns are presented. The selections that you make for this report do not affect the filters applied to the data.

    view table screen

    For the Pivot Table, add the pivot column, row, and data entries then choose the column Name, Type, and Format. To shift an entry to a different pivot type select it under Pivot Type.

    view pivot table

    For the Graphic section, you can attach the query data to different chart diagram types. The following chart types are available from the Diagram Type dropdown:

    • Bar Chart,

    • Bar Chart (3D)

    • Bar Chart Stacked

    • Bar Chart Stacked(3d)

    • Pie Chart, Pie Chart 3D

    • Line Chart

    • Line Chart Stacked Line

    There three different diagram types available:

    • Bar

    • Pie

    • Line

    Bar and Pie types can be display with a 3D effect. Bar and Line diagrams can be drawn as stacked diagrams (values on the y-axis summarized).

    view graphic page
  3. Click Save or Save As to save your View configuration to the query.

  4. Click Run to run your query.

ProcedureHow to Define Series for Diagrams

There are two ways to define the data series for a diagram.

Steps
  1. Series from columns: All column values are added to a series. The name of the series is the column header

  2. Series from rows: All column values define the series. The names of the series is defined by the values of the label column. The values of the series are defined by the value column.

Example 5-1   The query "Accounting per Department" results in a table with the columns: time, department, and cpu.
example columns and rows table
Example 5-2   Displaying the Results- Selecting Configuration

To display the result in a pie chart select the following configuration:

example series config
Example 5-3   Displaying the Results - Pie Charts

The result will be a multiple pie charts

pie charts
Example 5-4   Cpu, Io, and Mem Usage Over All Departments

A query summarizes cpu, io, and mem usage over all departments:

Usage example
Example 5-5   Displaying the Results - Selecting Configuration

To display the results in a bar char select the following configuration

bar chart config page
Example 5-6   Displaying the Results - Bar Chart

The results will be a bar chart with three bars for each department:

ProcedureHow to Run a Simple Query

Step
  • You can run a simple query that you just created. You can also run a simple query that you previously saved.

    • To run a query that you just created, click Run on the Simple Query screen.

      run simple query page
    • To run a query that you previously saved, select the query from the Query List screen , and then click Run.

Previous Previous     Contents     Index     Next Next