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 dialog to change how the currently displayed worksheet looks and behaves. You can:
change which items are displayed, their position on the worksheet, and how they look
create, edit, and remove worksheet items such as conditions, calculations, exceptions, percentages, totals, and parameters.
Note: For more information about maximizing Discoverer performance, see "About designing workbooks for maximum performance".
For more information about tabs on this dialog, see:
"Edit Worksheet dialog: Worksheet Layout tab"
"Edit Worksheet dialog: Select Items tab"
"Edit Worksheet dialog: Crosstab Layout tab"
"Edit Worksheet dialog: Table Layout tab"
"Edit Worksheet dialog: Sort tab"
"Edit Worksheet dialog: Parameters tab"
Properties
Use this button to display the Worksheet Properties dialog. Use the Worksheet Properties dialog to specify:
how Discoverer names worksheets (see "Worksheet Properties dialog: General tab")
how Discoverer formats worksheets (see "Worksheet Properties dialog: Sheet/Crosstab Format tab")
how Discoverer handles worksheet aggregation (see "Worksheet Properties dialog: Aggregation tab")
Show SQL
Use this button to display the SQL Inspector dialog, which shows the underlying SQL code for the current worksheet that Discoverer uses to extract data from the database. For more information about SQL, see "Using SQL".