Skip Headers
Oracle® Business Intelligence Enterprise Edition Help
11g Release 1 (11.1.1)
  Go To Table Of Contents
Contents


Layout pane

Use this pane to specify the layout of data in data views (funnel graphs, gauges, graphs, performance tiles, pivot tables, tables, treemaps, and trellises).

For more information, see:

This pane is part of the following editors:

Components Common to All Data Views


Note:

This section describes the components that are common to all data views. Additional components are available in the:


Drop Targets

Use drop targets to modify the way that data is arranged in a view. By dragging columns from one drop target and dropping them in another, you can rearrange the data to suit your needs.

The drop targets that are displayed in this pane depend on the type of view. For more information, see "Understanding Drop Targets."

Properties

Use this button to display the Properties dialog for a drop target. For example, if you click the button beside the Sections drop target, then the "Section Properties dialog" is displayed. If you click the button beside the view type name for tables and pivot tables, then the Properties dialog for that type of view is displayed.

Additional Components Common to the Graph, Funnel, and Gauge Editors

This topic is not applicable for waterfall graphs.

Display as Slider

Use this box to specify whether the members of the columns dropped in the Sections drop target are to be displayed as a section slider rather than as unique views. Select this box to display the members as a section slider.

Deselect this box to display each member as a unique view.

Deselect this box to hide sliders in graph views that listen to master-detail events, if you want to simplify the appearance of an analysis or dashboard.

For more information on section sliders, see "Defining Section Sliders in Graphs, Gauges, and Funnels."

Use unified scale

This box is available only for line-bar graphs.

Use this box to specify whether to display the lines and bars using the same scale or two separate scales, one for the lines and one for the bars.

Select this box to use one scale for both the lines and bars. The measure column that has the higher values is used for the scale.

Deselect this box to use two scales.

Show In Legend

Use this box to specify whether a legend is to be displayed to show the color variation of the columns dropped in the Vary Color By (Horizontal Axis) drop target.

Additional Components Common to Waterfall Graphs

Show Legend

Use this check box to display the legend. This check box is automatically selected and borders are turned off by default. If the format of the graph is set to Single Color, the legend does not display. See "What Types of Waterfall Graph Formats Are Available?" for additional information.

Totals

Use this button to add a subtotal or total for the view and to display the following options:

Group By (Horizontal Axis) — Use this button to perform groupings. Dimensions are dropped into this drop target. Select a single grouping column on which to subtotal, click the Totals button to the right of Group By, and then select one of the grouping columns from the list. The Summation icon displays on the grouping to which the subtotal was applied. The selection is reflected in the results pane, in the tooltip subtotals, and along the horizontal axis.

Additional Components Common to the Table and Pivot Table Editors

Totals

Use this button to add a grand total for that drop target for the entire view for attribute columns and hierarchical columns and to display the following options:

More Options

Use this button to display the following options:

Additional Components Common to the Trellis Editor

Visualization

Use this area to:

More Options

Use this button to display the following options:

Additional Components Common to Treemap Views

Group By

Use this area to create a header or group for the measure columns that are specified in the Size By and Color By areas.

Size By

Use this list to represent the distribution of the tiles within their parent. The size of the children will always equal the size of their parent. The first measure added in the Criteria tab is displayed as the Size By measure.

Color By

Use this list to represent a distribution of values across all of the tiles at the same level. The second measure added in the Criteria tab is displayed as the Color By measure. If only one measure is added to the analysis, both Size By and Color By will contain the same measure.

Color By is divided into two options: Style and Color.

Style

Use this list to specify the style for the treemap. Style contains two options: Percentile Binning and Continuous Color Fill.

Color

Use this list to select a color palette for the treemap.

See "Drop Target Guidelines for Treemaps" for additional information.


Aggregation Rules and Functions

The following list describes the aggregation rules that are available for measure columns in the "Layout pane" and for columns in the "Edit Column Formula dialog: Column Formula tab." The list also includes functions that you can use when creating calculated items for analyses.