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

Results tab: Data View editor

Use this editor of the "Analysis editor: Results tab" to edit one of the following data views:

For more information, see:

This editor is displayed as:

Results tab: Funnel editor
Results tab: Gauge editor
Results tab: Graph editor
Results tab: Map editor
Results tab: Performance Tile editor
Results tab: Pivot Table editor
Results tab: Table editor
Results tab: Treemap editor
Results tab: Trellis editor


Subject Areas

Use the "Subject Areas pane" to select the columns for an analysis and to work with subject areas.

Analysis Results

Displays the analysis results in a funnel graph, gauge, graph, map, performance tile, pivot table, table, treemap, or trellis, depending on the type of view.


This pane is not available for maps.

Use the "Layout pane" to specify the layout of the data for the view. Performance tiles have a unique Layout pane. See "Drop Target Guidelines for Performance Tiles" for additional information.

Treemap views have a unique Layout pane. See "Drop Target Guidelines for Treemaps" for additional information.


Use the "Catalog pane" to drag and drop named groups and named calculated items from the Oracle BI Presentation Catalog to the view. The Catalog pane is not available for performance tiles in edit mode on the Results tab. For more information on named groups and named calculated items, see "What are Inline or Named Objects?"

Selection Steps

This pane is available only in the Graph, Map, Pivot Table, Table, Treemap, and Trellis editors.

Use the "Selection Steps pane" to create and modify steps for data selections. Selection steps are not visible until you click the plus button (+) to expand the Selection Steps pane.


This pane is available only in the Funnel and Gauge editors.

Use the "Settings pane" to set the thresholds for a funnel graph or gauge.


The toolbar contains buttons that are common to all views and buttons that depend on the type of data view. For more information on the buttons common to all views, see "Toolbar Buttons Common to All Views." For more information on specific data view buttons, see "Data View Editor Toolbar."


Use this button to save your edits and return to the compound layout view.


Use this button to restore the settings in effect prior to your edits.

Right-Click Menu

Displays interactions that allow you to work with views. This option is available when you right-click a column heading or member in a table, pivot table, treemap, or trellis.

Paging Buttons

These buttons are available only when editing or working with tables, pivot tables, and trellises.

When a table, pivot table, or trellis includes a large number of rows, a set of buttons can be displayed under the view. You can use the following buttons to page through the rows in the view:

Components Specific to Map

Map View Area

Use this area to interact with the components of the map such as the zoom controls, legend, and overview map.

BI Data Layers

Use this area to work with the applicable formats for the BI layers of the map. Not all formats are available for all layer types. For example, point layers cannot have Color Fill formats. The map cannot display multiple non-point formats at a time (at a single zoom level) but can display multiple point formats simultaneously, if they do not share the same latitude and longitude location. If multiple graph formats are specified at the same geographic layer, then they render on top of each other.

You can do the following:

If no layers are specified in the map formats area, then click New Map Format. The map prompts you to import the geo-encoded columns for displaying a format for a particular geo-layer, if the columns are not part of the analysis.

When you specify to create a map view, you likely see at least one layer available in the Map Formats area. If no layer is available, then the New Map Format link is displayed.

Limits exist for how much data can be displayed for formats on a map view. As you work with formats, you might exceed the data limit. If you do so, then you see a message that alerts you to the data limit and the fact that not all formatting can be displayed, so you can contact the administrator. The administrator controls the limit with the MaxRecords configuration element. For information on setting this element, see "Manually Configuring for Map Views" in System Administrator's Guide for Oracle Business Intelligence Enterprise Edition.

Feature Layer

Use this area to add non-BI layers to the map. These layers have not been associated with BI data so are not interactive. Click New, then select the layer that you want to add to the map.

Components Specific to Performance Tiles

Styles pane

Use the Styles pane to select a predefined tile size option button or to select a new theme for your tile.

For more information, see:

Right-Click Menu for Data Views

When editing or working with pivot tables, tables, treemaps, and trellises, you can right-click to display a menu of interactions that are applicable to the view.

The interactions that are available when you right-click depend on:


Right-click interactions are not available for graphs in trellis views (Simple Trellis and Advanced Trellis), but you can right-click on text in the trellis view in the same manner as in a pivot table. This includes data cells in an advanced trellis that have Visualization set to Text.

The right-click menu can include the following interactions (listed in alphabetic order):

For more information on selections steps, see "Working with Selections of Data." For more information on groups and calculated items, see "Working with Groups and Calculated Items."


Toolbar Buttons Common to All Views

The following toolbar buttons are common to all views:

Data View Editor Toolbar

The toolbar on a data view editor contains some buttons that are common to all data views and other buttons and boxes that are particular to specific views. See the following sections:

Toolbar Buttons Common to All Data Views

The following toolbar buttons are common to all data views:


To add a new calculated measure to all views, click the New Calculated Measure button from within the "Analysis editor: Results tab."

Toolbar Buttons Specific to Graph and Funnel Graph Views

The toolbar contains the following buttons and boxes that are specific to a graph view:

Toolbar Buttons and Boxes Specific to Gauge Views

The toolbar contains the following buttons and boxes that are specific to a gauge view:

Toolbar Buttons and Box Specific to Map Views

The toolbar contains the following buttons and box that are specific to a map view:

See "Working with Map Views on Dashboard Pages" for more information.

Toolbar Buttons and Box Specific to Pivot Table, Table, and Trellis Views

The toolbar contains the following buttons and box that are specific to a pivot table, table, or trellis view:

Export Menu Options for Views and Results

You can use the following options to export the results of an analysis or a view. When you export the results of an analysis, any tables, pivot tables, trellises, or graphs that are displayed with the analysis are included.

For more information, see "Exporting Results."


Sorting Options Menu

The options that are available on the Sorting Options menu depend on the type of data view and the location in which you right-clicked and can include the following options:

In a pivot table that has more than one measure in a column (or a row), when you right-click and select one of the sorting options (such as Sort Ascending) to sort a row (or a column), options that allow you to select which measure to use in the sort are displayed.

For more information on sorting, see "Sorting Data in Views."