---

Worksheet Display page: (Page level tools and controls)

You can use the following controls and tools in a worksheet page:

• "<Hide/Show arrow icons>"

• "<Parameter tools>"

• "Page Items"

• "<Drill arrow icons>"

<Hide/Show arrow icons>

Use the Hide/Show arrow icons to hide or show information in the current worksheet. For example, click the arrow next to the word Crosstab to show (or hide) the crosstab. For more information, see "Worksheet Display page: (Table/Crosstab tools)".

<Parameter tools>

If the worksheet uses parameters, the following controls are available:

• Parameters

  Use the arrow icon to display or hide the current parameter values.

• <Torch icon>

  Use the torch icon to display the "Search and Select page" where you can search for and select parameter values to apply to the worksheet. For more information, see the "Edit Parameters page". Click Go to apply the changes.

Page Items

Discoverer displays page item selectors above each view of the worksheet data (e.g. crosstab, graph). The page item selectors enable you to select items to apply to the whole worksheet (e.g. if the Page Items list displays departments, select a department from the list to display data for the selected department).

Use the drop down list to choose a page item value to apply to a worksheet.

Up/Down links

Use these links to display worksheet pages where Discoverer returns more rows than it can display in one page of data.

Use the drop down list to select a value that determines how to display subsequent worksheet rows. For example, if you selected the value 3 rows, Discoverer Viewer would display the next 3 rows of data.

Left/Right links

Use these links to display worksheet pages where Discoverer returns more columns than it can display in one page of data.

Use the drop down list to choose a value that determines how to display subsequent worksheet columns. For example, if you selected the value 3 columns, Discoverer Viewer would display the next 3 columns of data.

<Drill arrow icons>

Discoverer Viewer enables you to drill into items to display additional data.

Use the drill arrow icons to display lower or higher levels of detail when using relational and OLAP connections as follows:

• When using a connection to a relational datasource, use a drill arrow icon to display a popup drill menu from where you can choose one of the following drill options:

  • Collapse

    Use this option to drill up and hide the drill items displayed at this level of the drill hierarchy. Collapse also hides all drill items from lower levels in the drill hierarchy.

  • All Hierarchies

    Use this popup menu to display a further popup menu of all the hierarchies created in the current business area (e.g. a date hierarchy). You can choose a hierarchy and then choose the hierarchy item you want to display in the worksheet.

  • Drill to Related

    Use this popup menu to drill to related items from folders in the current business area that are not already included in the worksheet.

  If you are not using a mouse you can navigate to the drill arrow icons using the tab key. When you press enter the "Drill page" is displayed. Use the Drill page to review the drill options and apply a new drill.

• When using a connection to an OLAP datasource, use a drill arrow icon to drill up or down the drill hierarchy to display different levels of detail as follows:

  • Expand

    Use this option to drill down to display data at the next level in the drill hierarchy.

  • Collapse

    Use this option to drill up and hide data from the current level in the drill hierarchy, and from all lower levels in the drill hierarchy.

  If you are not using a mouse you can navigate to the drill arrow icons using the tab key. When you press enter Discoverer will drill up or down depending on the following conditions:

  • If the currently highlighted drill arrow icon has not been expanded to a lower level of detail, Discoverer Viewer will drill down to display data at the next level down in the drill hierarchy.

  • If the currently highlighted drill arrow icon has already been expanded to a lower level of the drill hierarchy, then Discoverer Viewer will hide the data at this level and all lower levels.

About drilling out to view files created in other applications

Use the drill-out icon in a data cell to view files created in other applications. For example, clicking the symbol for a MS Word file launches MS Word within the browser and displays the file.