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


Table Properties dialog: Style tab

Use this tab of the "Table Properties dialog" to specify formatting preferences for tables and pivot tables.

For more information, see "Editing Table and Pivot Table Views."

This dialog is also displayed as:


Pivot Table Properties dialog

Components

Data Viewing

Use this area to specify the method to use to browse data:

Maximum Width

This field is available only if Fixed headers with scrolling content is selected.

Use this field to specify the maximum width of the table or pivot table in pixels.

Maximum Height

This field is available only if Fixed headers with scrolling content is selected.

Use this field to specify the maximum height of the table or pivot table in pixels.

Paging Controls

This box is available only if Content paging is selected.

Use this box to specify where the paging controls are displayed for the view. The paging controls include First 25 Rows and Next 25 Rows. You can select either the top or bottom of the view or you can select to hide the controls. For information on the paging control buttons, see "Results tab: Data View editor."

Rows per Page

This field is available only if Content paging is selected.

Use this field to enter the number of rows to display per page for the view. This setting affects the number of rows that are displayed with the First, Next, and Previous paging control buttons.

Display Column & Folder Headings

Use this box to specify whether to display headings for the columns and the view. You can select from the following:

Enable alternate styling

Use this box to specify whether to add "green bar" styling to the view. Green bar styling shows alternating rows or columns in a light green color. (Light green is the default color, which you can change. For how, see "Applying Formatting to Tables and Pivot Tables.") Select this box to add green bar styling. Deselect it to omit green bar styling.

Alternate

This field is enabled only if you select the Enable alternate styling box and you are applying formatting to a pivot table.

Use this box to select one of the following options for green bar styling for pivot tables:

Repeat Cell Values

Use this box to indicate that all cells that span rows are repeated. For example, suppose that you have a table that has Year and Month values. When this box is not selected, Year is displayed once for Month values. When this box is selected, Year is repeated for all Month values. This box is available only for tables.

Set Alternate Format

Use this button to display the "Edit Format dialog," where you add cosmetic formatting for the green bar styling of the view. See "Applying Formatting to Tables and Pivot Tables."

Listen to Master-Detail Events

Use this box to specify whether a table or pivot table is to act as a detail view in a master-detail relationship and listen for master-detail events. If you select this box, then complete the Event Channels field.

For information on master-detail relationships, see "What Is Master-Detail Linking of Views?"

Event Channels

This field is enabled only if you select the Listen to Master-Detail Events box.

Use this field to enter one or more channels on which the table or pivot table is to listen for master-detail events raised by one or more master views. The channel name is case sensitive and must match exactly the channel name specified in the master view. Separate channels with commas, for example, channel a, channel b.

The remaining components of this dialog are described in "Column Properties dialog: Style tab."

Null Values

Use these check boxes to override null suppression set at the analysis level.

Include rows with only Null Values — Use this check box to include null values in a table or pivot table view when the entire row contains all null values. When selected, null values are not suppressed for rows for the table or pivot table.

Include columns with only Null Values — This check box is available only for pivot table views. Use this check box to include null values in a pivot table view when the entire column contains all null values. When selected, null values are not suppressed for columns in the pivot table.

See "Understanding Null Suppression" for additional information.

Notes