The Measure Data Viewer displays the selected measure in a crosstab at the top of the page and a graph at the bottom of the page. To make extensive changes to the selection of data, choose Query Builder from the File menu.
Each display has its own format toolbar. Tooltips provide brief descriptions of the tools, which you can see by resting the cursor over a tool.
The text formatting tools are the same on both toolbars. You can change the font, the font size, font color, fill color, and the alignment of the text. To change the format, select the text first, then click the tool.
On a crosstab, you can format the selected cells as plain numbers, or add currency symbols or percent signs. You can also add and remove decimal places by clicking the Decimal tools one or more times.
On a graph, you can change the graph type, add or remove a legend or grid lines, or add three-dimensional or gradient-color effects.
In the initial cross-tab display, the members of the fastest-varying dimension label the columns, and the members of the next-fastest varying dimension label the rows. The members of the other dimensions label the pages. You can view only one page at a time.
You can expand and collapse the dimension hierarchies that label the rows and columns. You can also change the location of a dimension by pivoting or swapping it. If you wish, you can use more than one dimension to label the columns and rows, by nesting one dimension under another.
To pivot, drag a dimension from one location and drop it at another location, usually above or below another dimension.
The format of the graphic display is controlled by the crosstab. If you want to change the dimension on the X-axis, for example, you must change the layout of the crosstab.
Using the Graph Type tool, you can change the type of graph. Different graph types reveal different characteristics of the data. The following table describes common uses for the various graph types.
| Graph Type | Usage |
|---|---|
Bar |
Trends over time; comparisons, such as Sales in different regions |
| Pie | Percentage or comparisons of percentages; relationship between the parts and the whole |
| Line | Trends over time; rate of data change |
| Area | Trends over time; rate of data change |
| Combination | Trends over time; effect of one variable on another |
| Scatter | Correlations of two or three measures |
| Stock | Stock prices over time |
| Circular | Cyclical or directional patterns |
| Pareto | Highest and lowest contributors to a total; ranking |
| 3-D | Three-dimensional view of trend or comparison |
Copyright © 2003, 2007, Oracle. All rights reserved.