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


BI Composer wizard -- Create Analysis: Edit Table panel

This panel is available only if you have added a tabular view to the analysis using the "BI Composer wizard -- Create Analysis: Select Views panel."

Use this panel of the "BI Composer wizard" to:

For more information, see:

This panel is also displayed as:


Edit Analysis Analysis_Name: Edit Table panel

Components

Rows

This target area is available only for a pivot table.

Displays the columns that are to be shown as rows in a pivot table.

Use this target area to modify the way that data is arranged in the pivot table by moving rows to different target areas.

To move a column, select the column, click Move To, and then select one of the options on the Move To menu.

Columns

Displays the columns that are to be shown as columns in a table or pivot table.

Use this target area to modify the way that data is arranged in the table or pivot table by moving columns to different target areas.

To move a column, select the column, click Move To, and then select one of the options on the Move To menu.

Move To

Displays the following options to move a column to a different target area:

Additional Layout Options

Use this option to display the following target areas Prompt For, Section By, and Excluded.

Prompt For

Displays the columns that are to be displayed as prompts.

Use this target area to move a column to another other target area.

To move a column, select the column, click Move To, and then select one of the options on the Move To menu.

Section By

Displays the columns that are to be to used to divide the table or pivot table into sections.

Use this target area to move a column to another target area.

To move a column, select the column, click Move To, and then select one of the options on the Move To menu.

Excluded

Displays the columns that are to be excluded from the view.

Use this target area to move a column to another target area.

To move a column, select the column, click Move To, and then select one of the options on the Move To menu.

Up and Down Arrows

Use these buttons to reorder the columns in the target areas.

Preview

Use this box to specify whether to display a preview of the results:

Show how results will look on a dashboard

Use this button to show a fully interactive view where you can page through large result sets, drill, and so on.

Report XML

Use this button to show the XML code for the analysis. This information is helpful for debugging purposes.