Oracle® Fusion Middleware User's Guide for Oracle Business Intelligence Discoverer Plus 11g Release 1 (11.1.1) Part Number B40105-01 |
|
|
View PDF |
Use this tab to specify how the current worksheet is displayed. Use this dialog to:
display or hide headings, gridlines and row numbers
define crosstab style and gridline color
define how to display null values
show drill links as icons
For more information, see:
Table headers (options displayed for tabular worksheets)
Show column headings
Use this check box to display or hide column headings on the current worksheet. You might want to hide column headings, for example if they are not required on a worksheet. Discoverer displays column headings by default.
Show row numbers
Use this check box to display or hide row numbers on the current worksheet. You might want to show row numbers, for example to enable users to use the row numbers to locate a specific worksheet row. Discoverer displays row numbers by default.
Crosstab headers (options displayed for crosstab worksheets)
Show item labels
Use this check box to display or hide the crosstab item labels on the current worksheet (for example, Region). If item labels have been defined, they are displayed on the crosstab vertical or side axis.
Show heading gridlines
Use this check box to display or hide crosstab heading gridlines on the current worksheet.
3D heading gridlines
Use this check box to display the crosstab heading gridlines in 3D style. This check box is only enabled when the Show heading gridlines check box is selected.
Crosstab style
Use this drop down list to select a value to configure the side (left) axis on a crosstab as follows:
Inline
Choose this option to display the first child row, on the same row as its parent. For example, on a worksheet that shows Years and Months, January (the first child row) appears on the same row as the year 2001 (the parent row).
Outline
Choose this option to display the first child row on the row below its parent. For example, on a worksheet that shows Years and Months, January (the first child row) appears on the row below the year 2001 (the parent row).
Show vertical gridlines
Use this check box to display or hide the vertical gridlines (in the data cells).
Show horizontal gridlines
Use this check box to display or hide the horizontal gridlines (in the data cells).
Gridline color
Use this button to change the color of the gridlines that are displayed in the data cells.
Show null values as
Use this drop down list to specify how Discoverer displays null (or empty) values. For example, if you typed the words No information available in this field, Discoverer displays this text when there is no data for a cell. Discoverer displays a blank cell by default.
Example
This area shows you how the worksheet looks, with the options you have set.