Worksheet Display page: (Table/Crosstab tools)

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 (for example, 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 (for example, 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 (does not affect the worksheet page navigation tool).

Discoverer provides the following table/crosstab tools:

• "Layout"

• "Format"

• "Stoplight"

• "Sort"

• "Saved Selections"

• "Rows and Columns"

• "|<< < Page x of y > >>| <worksheet page navigation>"

  This tool is only displayed when the pageNavigation setting is set to True (using the Oracle Fusion Middleware Control MBean Browser). For more information, see Oracle Fusion Middleware Configuration Guide for Oracle Business Intelligence Discoverer.

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 (for example, 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 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 (for example, 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 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. This setting only applies to the current worksheet.

• Rows

  Use this field to set the maximum number of rows of data that Discoverer displays on a page.

• Columns

  Use this field to set the maximum number of columns of data that Discoverer displays 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.

|<< < Page x of y > >>| <worksheet page navigation>

Use this tool to navigate through worksheet pages, when multiple pages of data are returned. View pages by clicking the buttons or the Page x of y link as follows:

• |<< - <Go to first page>

  Use this button to display the first page.

• < - <Go to previous page>

  Use this button to display the previous page.

• Page x of y

  Use this link to display the Go to page field, where you enter a page number, and then click Go to display the specified page.

  Note: In the Page x of y link, the letter x represents the number of the currently displayed page, and the letter y represents the total number of pages.

• > - <Go to next page>

  Use this button to display the next page.

• >>| - <Go to last page>

  Use this button to display the last page.

• Go to page

  Use this field to enter the number of the page that you want to display.

  Note: This field is displayed below the worksheet.

• Go

  Use this button to display the page number that you entered in the Go to page field.

  Note: This button is displayed below the worksheet.

Note: This tool is only displayed when the pageNavigation setting is set to True (using the Oracle Fusion Middleware Control MBean Browser). For more information, see Oracle Fusion Middleware Configuration Guide for Oracle Business Intelligence Discoverer.