Specify the Graph Dimensions

This topic describes how to specify or modify the following properties of a graph:

Vertical axis values

Category

Vertical axis properties

Steps

Access the graph for which you want to specify the graph dimensions.

Tip: You can also access a graph from the Catalog.

In the pane, select Dimension Mapping.

The Dimension Mapping workspace appears.

The Dimension Mapping workspace

Note: If you are mapping the dimensions for a heat map or color scale graph, you will be mapping columns instead of a series.

In the Vertical Axis Values section, select Map Series.

The Dimension for Series window appears.

Note: If you are creating a color scale graph, the Vertical Axis Value must be taken from the query column that returns the name of the color displayed on the color scale. The logic for determining the color for each row of query results should be embedded in the query itself using any valid HTML color name or code. For example, the following query determines colors based upon the value of another column:

SELECT [MC_MTCRD].[MC_MTCRD_TIME_STAMP_D] "Timestamp"

, Decode([MC_MTCRD].[MC_MTCRD_VALUE_C], 'RUNNING', Green', 'INFEEDHOLD', 'Yellow', 'DOWNLOADING', 'Yellow', 'ABORTED', 'Red', 'Orange') "Color"

FROM [MC_MTCRD]

ORDER BY [MC_MTCRD].[MC_MTCRD_TIME_STAMP_D] Asc

The Dimension for Series window

Select the dimensions that you want to plot on the vertical axis, and then select Apply.

The selected dimensions appear in the Vertical Axis Values section.

In the Category section, select Map Category.

The Dimension for Category window appears.:

Note: If you are creating a time series graph, the Dimension for Category must be time stamp.

The Dimension for Category window

Select the category that you want to plot on the x-axis, and then select Apply.

The selected category appears in the Category section.

Select .

If you have created a new graph, in the Save As window that appears, in the pane, navigate to the catalog folder in which you want to save the graph, provide the details of the graph, and then select Save.

-or-

If you have accessed an existing graph, in the window displaying confirmation that the graph is saved, select OK.

The changes made to the graph dimensions are saved.