... |
|
|
... |
... |
|
|
Analyzing
Data with Drills
Ownership
The Director of the Business Support
Center is responsible for
ensuring that this document is necessary, reflects actual practice, and
supports University policy.
Section
Objectives
At the end of this section, you should be
able to:
-
Identify the drill types
-
Use the drill facility to
display detail information
-
Use the drill facility to
summarize data
-
Set the drilling options
-
Drill to detail in another
sheet
Types of Drilling
Drill Up/Down (Predefined Hierarchy): Drill
Up displays summarized information related to a selected item, and Drill Down
shows less-aggregated data or more details about an item.
Drill to a Related Item (Non-predefined Hierarchy): Drill
to a Related Item leads you to an item that is not in the hierarchy
Drill to Detail: You can either drill to
show component rows or associated folders. Drilling to component rows shows all
detail rows that make up that summary. Associated folders are folders that have
been designated “related” by the Discoverer administrator. Note:
None are designated in the ODS now.
Customizing
Displaying
the Drill Dialog Box
Use any one of the following methods to
display the Drill dialog box:
-
Click the right mouse
button.
-
Select Sheet—>Drill.
-
Double-click a data value.
-
Click the drill icon on the
toolbar.
Selecting
the Drill Type
-
Select an
item or item header and then launch the Drill dialog box. The Drill dialog box
appears with the selected item displayed.
or
-
Select a data value for a
hyperdrill or clear all items and then launch the drill facility. The Drill
dialog box appears with a list of items from which you can drill.
-
Select the type of
drill. A list of possible items to which
you can drill is displayed.
-
Select [OK] to execute the
query.
Setting Drill
Options
Once you have selected the type of drill to
run, you can use the Drill Options dialog box to customize the results of the
drill. The drill options are as follows:
-
When drilling to a new item,
current item is: Specify whether to expand or replace the drill item.
-
Place drill results in:
Specify whether to place the results of the drill in the current sheet or in a
new sheet.
-
Display results as: If the
results are to be displayed in a new sheet, specify a layout style.
-
Before query is run: To
perform additional layout modifications, select the “Let me modify query before
proceeding” check box, which opens the wizard.
Summary
In this lesson, you should have learned how
to:
-
Identify the drill types
-
Use the drill facility to
display detail information
-
Use the drill facility to
summarize data
-
Set the drilling options
-
Drill to detail in another
sheet
Effective: 02/03/06 njk
Revision: 3
Copyright 2004 University of Virginia and Oracle Corporation. All rights reserved.
Oracle® Tutor Copyright © 1997, 2004, Oracle. All rights reserved.
