Oracle® Business Intelligence Discoverer Viewer User's Guide,
10g Release 2 (10.1.2.0.0) Part No. B13987-01 |
|
![]() Previous |
![]() Next |
When a query has run, Discoverer displays the worksheet data as either a table or a crosstab, depending on how the worksheet was created:
A table arranges items in columns. Items appear as column headings along the top axis. A table is typically used to list all information that fits the query criteria (e.g. sales transactions for the last month).
Note: Tables are only displayed in worksheets that use relational data.
A crosstab arranges items or measures in rows and columns. A crosstab is typically used to display summary information and shows how one item or measure relates to another (e.g. sales by region by month).
Note: Crosstabs can be displayed in worksheets that use both OLAP and relational data.
Table/Crosstab
Use the arrow icon to display or hide table or crosstab data.
Tools
Use the arrow icon to display or hide the table or crosstab tools.
Discoverer provides the following table/crosstab tools:
Layout
Use this tool to rearrange the layout of the worksheet data.
Use the drop down lists to:
move a worksheet item to a specified position on the worksheet
Use the Move option from the first drop down list, select the item that you want to move from the second drop down list, and select the location to move the item to using the third drop down list.
swap worksheet items, rows, columns or page items with one another
Use the Swap option from the first drop down list, select a worksheet item, row, column, or page item from the second drop down list, and select an option to swap with, from the third drop down list.
Use the More link to display the "Table / Crosstab Layout page", which enables you to rearrange the layout of worksheet data.
Format
Use this tool to format selected worksheet data cells.
<bold>, <italic> and <underline> buttons
Use these buttons to apply bold, italic and underline formats to the selected worksheet cells.
Number
Use this field to select a number format from the drop down list, to format the data in the worksheet (e.g. currency, percentages).
Use the Go button to apply the number formatting to the selected cells.
Background
Use the icon to display the color picker where you select a background color.
Use the Go button to apply the background color to the selected cells.
Font
Use the icon to display the color picker where you select a font color.
Use the Go button to apply the font color to the selected worksheet text.
More
Use this link to display the "Format Cells page" where you specify format options for selected crosstab worksheet cells.
Create Conditional Format
Use this link to display the "Create Conditional Cell Format page", where you can create a new conditional format to highlight worksheet values.
Conditional Formats
Use this link to display the "Conditional Formats (Table/Crosstab) page", where you can create, edit and delete conditional formats for the data in the worksheet.
Stoplight
Use this tool to define a stoplight format to categorize data for the current worksheet. Discoverer can apply one of three stoplight colors to worksheet data depending on the value of the data. The stoplight colors represent unacceptable, acceptable, and desirable data ranges.
Format
Use this field to specify what to apply the stoplight format to (e.g. selected cells, all worksheet cells).
Unacceptable
Use this field to enter a value that specifies the unacceptable values of the stoplight range. When the value of worksheet data is less than or equal to this value, Discoverer displays the data in the color displayed in the color picker icon. To change the color displayed in the color picker icon, click the color picker icon and select a new color from the color palette.
Acceptable
Discoverer determines this range as falling between the unacceptable and desirable values. When worksheet data values falls within this range, Discoverer displays the data in the color displayed in the color picker icon. To change the color displayed in the color picker icon, click the color picker icon and select a new color from the color palette.
Desirable
Use this field to enter a value that specifies the desirable values of the stoplight range. When the value of worksheet data is greater than or equal to this value, Discoverer displays the data in the color displayed in the color picker icon. To change the color displayed in the color picker icon, click the color picker icon and select a new color from the color palette
Go
Use this button to apply the stoplight settings for the specified data values in the current worksheet.
Conditional Formats
Use this link to display the "Conditional Formats (Table/Crosstab) page", where you can create, edit and delete conditional formats for the data in the worksheet.
Sort
Use this tool to sort the worksheet data based on selected criteria in a worksheet.
Note: This tool is displayed with table worksheets and with worksheets created using OLAP connections.
Sort
Use this drop down list to select the values that you want to use to sort the worksheet data.
Based on
Use this drop down list to select a item or measure on which to base the sort order for the values that you selected in the Sort drop down list.
Note: This option is only displayed with worksheets created using OLAP connections.
For
Use this drop down list to specify the dimension members to use when sorting based on measure values.
Note: This option is only displayed with worksheets created using OLAP connections.
Order
Use this drop down list to select a sort order for the values that you selected in the Sort drop down list.
Go
Use this button to apply the sort settings in the current worksheet.
More
Use this link to display the "Multiple Sort page", where you can specify how Discoverer Viewer sorts the data displayed in multiple worksheet columns.
Note: This link is not displayed for worksheets created using OLAP connections.
Saved Selections
Use this tool to apply a previously saved selection to a dimension that is displayed in the worksheet.
Note: This tool is only displayed with worksheets created using OLAP connections.
Dimension
Use this drop down list to select the dimension to which you want to apply a saved selection.
Action
Use this drop down list to specify whether to add, keep, remove, or replace the members from the specified saved selection, as described in the following list.
Add
Adds the members from the specified saved selection to the current selection.
Keep
Keeps the members from the specified saved selection that were already present in the current selection and discards all other members.
Remove
Removes any members from the current selection that are specified in the saved selection.
Replace with (Default value)
Replaces the current selection with new members from the specified saved selection.
Saved Selection
Use this drop down list to select the saved selection that you want to use.
Go
Use this button to apply the saved selection to the dimension in the worksheet.
Rows and Columns
Use this tool to set the number of rows and columns you want to display on each page. You can change the default number of rows and columns that Discoverer displays here (for more information, see "Preferences page").
Rows
Use this field to set the maximum number of rows of data that Discoverer will display on a page.
Columns
Use this field to set the maximum number of columns of data that Discoverer will display on a page.
Go
Use this button to apply the numbers of rows and columns that you want to display on each page in the current worksheet.