Skip Headers

Oracle® Business Intelligence Discoverer Viewer User's Guide,
10g Release 2 (10.1.2.0.0)
Part No. B13987-01
  Go To Documentation Library
Home
Go To Product List
Solution Area
Go To Table Of Contents
Contents
Go To Index
Index

Previous
Previous
Next
Next
 

Worksheet Options page

This page enables you to change some settings related to the current worksheet.

Display Options

Title

Use this check box to display the title in the worksheet.

Table/Crosstab

Use this check box to display the table or crosstab data in the worksheet (displayed with Oracle Applications or relational database connections).

Use this radio button to display the crosstab data (displayed with worksheets created using OLAP connections).

Graph

Use this check box to display the graph in the worksheet (displayed with Oracle Applications or relational database connections).

Use this radio button to display the graph in the worksheet (displayed with worksheets created using OLAP connections).

Both

Use this radio button to display the graph and the crosstab data in the worksheet (only displayed with OLAP connections).

Text Area

Use this check box to display the text area in the worksheet.

Sheet Options

Show axis labels

Use this check box to display crosstab header labels in the worksheet.

Show null values as

Where no data is returned for a field in a worksheet you can define here how the data is displayed. For example, if you enter 'Zero' in this field, worksheets will display the word 'Zero' where no data is returned.

Show values that cannot be aggregated as:

When a worksheet tries to aggregate an item that cannot be aggregated (for example Rank), you can define here how the data is displayed. For example, if you enter 'N/A' in this field, worksheets will display the text 'N/A' where the data cannot be aggregated.