1
Discoverer Desktop Overview

This chapter explains the basic concepts of Oracle Discoverer Desktop. Being familiar with these concepts will help you work more effectively with Discoverer.

The topics covered in this chapter include:

• New Discoverer Desktop Features

• How Discoverer Desktop Works

• Opening a Workbook

• Saving a Workbook

1.1 New Discoverer Desktop Features

Discoverer Desktop Version 9.0.4 provides support for the Discoverer End User Layer that is created and maintained by Discoverer Administrator Version 9.0.4.

1.2 How Discoverer Desktop Works

Oracle Discoverer Desktop is a data access tool. You use it to view the information in your company's databases. The whole purpose of Discoverer is to help you--the business professional--view the data you want from a database, analyze it to support your business decisions, and create reports to keep track of things.

Figure 1-1 Oracle Discoverer

Text description of the illustration workbook.gif

Discoverer solves many of the problems normally associated with databases so that now you can easily:

• Find data that you know is in the database.

• See data displayed quickly without waiting for the computer to spend a long time searching through the entire database.

• View data in a familiar format that is easy to read and understand.

• Analyze data using a wide array of techniques including drilling up and down through the data's details, finding data that meets certain conditions or that falls within ranges you specify, sorting data, comparing results from "what if" scenarios, and so on.

• Prepare reports of your analytical results and findings.

• Share data with others, and in other applications (such as Excel).

Discoverer uses a new, unique way of accessing data. Comparing Discoverer with previous data-access methods can help you understand the new concepts that you will use with the Discoverer Desktop.

The following two figures compare the old fashioned, data access methods with the new Discoverer methods.

Figure 1-2 The Old-Fashioned Method of Data Access

Text description of the illustration 1introb.gif

Figure 1-3 The Discoverer Method of Data Access

Text description of the illustration 1intro25.gif

1.2.1 What is a Business Area?

A business area is a logical grouping of database tables or views that apply to your specific data requirements. For example, the accounting department wants data about budgets and finance, while project leaders want data specifically about their projects as well as about budgets. Although some of the data you need may be the same (such as the budgets folder as shown in the following figure), the exact combination of tables and views for each department is usually unique. Using Discoverer Administrator, your Database administrator tailors the grouping of data to provide you with the proper access to the precise data needed for analysis, decision support, and presentation of results.

Figure 1-4 Business Areas and Folders

Text description of the illustration 1intro3a.gif

1.2.2 Understanding Workbooks and Worksheets

Think of a workbook as a three-ring binder filled with specific data for specific tasks. The workbook has pages, or worksheets, that contain data for the specific tasks. For example, if the workbook is for sales and profit data, one worksheet in it might be a table listing your profit for sales versus rentals. Another worksheet might be a comparison of your profit over the last two years by sales region.

The sample database that you receive with Discoverer contains data from a fictitious video store business. The sample data covers many topics including:

• Sales Region

• Year

• Department

• Sum of Profit

• Size of Store (in square feet)

• Type of Store Design (Compact, Modern, or traditional)

• Store Name, and so on.

Discoverer also comes with its own sample workbooks, that you can use to analyze the example data.

Figure 1-5 Sample Worksheets

Text description of the illustration 1intro8.gif

Key to Figure 1-5

1. These two worksheets are from the same workbook. They are both designed for analyzing profit.

2. This worksheet is a table. It lists the data in a familiar tabular format.

3. This worksheet is a crosstab. It shows the data in a more aggregate form that is usually better for data analysis than tables.

1.2.3 About Worksheets and Queries

A query is simply a search of the database that finds and retrieves the data you want. Each worksheet in a workbook contains the result of a query. So, when you see the term "query" while working with Discoverer Desktop, you can think of it as a worksheet with retrieved data.

1.3 Opening a Workbook

Your Database Administrator usually supplies the various passwords and server access instructions to log on to Oracle Discoverer Desktop and open a workbook. The following steps explain the basic process.

The Database Administrator at your company will have designed the workbooks that you can open. If you have questions about the workbook names, whether you have access to them, the location of workbooks on company servers, and so on, see your Database Administrator.

To open a workbook:

1. From the Windows Start menu, choose Programs | Oracle Developer Suite - <HOME_NAME> | Discoverer Desktop | Oracle Discoverer Desktop.

   The Oracle Discoverer connect dialog appears (Figure 1-6). Your user name should already be in the Username box. If not enter it in the Username box.

   Figure 1-6 Connect to Oracle Discoverer

   
   
   Text description of the illustration connect1.gif

2. In the Password box, enter your password

3. In the Connect box, enter the name of the database that you wish to use.
   See your Database Administrator for password and database name details.

For information about connecting to an Oracle Applications EUL, see Appendix , "This Appendix contains the following sections:".

4. Click Connect.

   The first screen of the Workbook Wizard appears. The wizard steps you through the process to get the specific data you want to see.

   Figure 1-7 The Workbook Wizard

   
   
   Text description of the illustration strtwiz1.gif

   Create a new workbook--starts the process to create a new workbook. This option is not available if you don't have access rights granted by the Database Administrator. See Chapter 7, "Building Worksheets and Workbooks" for details about creating a new workbook.

   Open an existing workbook--shows options for opening one of your existing workbooks.

   5. Click Open an Existing Workbook. The next Workbook Wizard dialog box shows options for opening your existing workbooks:

      Figure 1-8 Opening an Existing Workbook

      
      
      Text description of the illustration strtwiz2.gif

   My Computer--opens a dialog box for selecting a workbook stored on your local computer or on a server on your business network.

   Database--opens a dialog box for selecting a workbook stored as part of a specific database. The workbook can be shared easily with others who have access to the database.

   Scheduling Manager--displays a list of workbooks previously scheduled to run at a certain times (usually overnight, on a weekend, or at some periodic interval). Scheduled workbooks run automatically and are available when you need to open them.

   Recently Used List--shows the workbooks you've previously opened (see Figure 1-9 for an example). If you usually work with the same workbooks on a daily basis, this option is the quickest way to open a workbook.

   Figure 1-9 A Discoverer Most Recently User Workbook List

   
   
   Text description of the illustration strtwiz3.gif

   If you choose My Computer from the Where is the workbook you want to open? options, a dialog box appears for you to select the workbook to open:

   Figure 1-10 Select a Workbook to Open

   
   
   Text description of the illustration opendb1.gif
   6. Select the workbook name and click Open, or just double-click the name.

      A dialog box asks if you want to run the query for the worksheet.

      Figure 1-11 Run the Query Confirmation

      
      
      Text description of the illustration runqury.gif

      A query causes Discoverer to find the most recent data to fill in the worksheet. Normally you click Yes because you want to see the most recent data associated with the sheet. Click No if you don't want to see the data in the worksheet. For example, click No if you want to create a new worksheet and don't need to see the data on the existing worksheet. See Chapter 7, "Building Worksheets and Workbooks" for details to create a new worksheet.

      7. Discoverer now evaluates the query to determine how much time it will take to open the workbook and shows you an estimate. Click Yes to see the data.

         Figure 1-12 Time Estimate

         
         
         Text description of the illustration timeest.gif

      This dialog box is mainly for your convenience because, if the query time is more than a few minutes, you can be doing other work while Discoverer gets the data for the worksheet.

      If you can't wait the estimated time, click No. Discoverer will remain open, but the worksheet will be empty.

      If you click Yes, a dialog box shows you the progress and elapsed time while Discoverer is finding the data. At the end of the process, your workbook appears. Here's a sample:

      Figure 1-13 A Discoverer Workbook

      
      
      Text description of the illustration fulscren.gif

      1.3.1 Opening Another Workbook

      You can open several workbooks at a time and switch back and forth between them. This is an excellent way to compare data to find specific analytical results.

      When several workbooks are open at the same time, use the Window menu to switch between them:

      Figure 1-14 Window Menu

      
      
      Text description of the illustration wndwmnu.gif

      To open another workbook:

      1. Choose File | Open.

         The Open Workbook dialog box appears. Its options are the same as when you were opening the first workbook (see Figure 1-8).

         Figure 1-15 Open Workbook Dialog Box

         
         
         Text description of the illustration openwkbk.gif
      2. Click one of the options.

         A dialog box for the selected Open Workbook type appears.

         Figure 1-16 Selecting a Workbook from My Computer

         
         
         Text description of the illustration opendb1.gif
         3. Select a workbook and click Open.

            If the workbook you select is stored in another database account, a dialog box appears for you to open the new workbook.

            Figure 1-17 Open a Workbook in Another Account

            
            
            Text description of the illustration dfrtdab.gif
            4. Click one of the options and click OK.

               If you select the first option in the dialog box, the workbooks currently open will close before the new workbook opens. A message gives you the option to not close the currently open workbooks.

               Note: You can turn off this dialog box. See Section 8.5, "Setting Options".

            1.3.2 Opening Workbooks in a Non-Oracle Database

            If your business uses other, non-Oracle databases your Database Administrator can set up Discoverer to open workbooks in those databases. You can then use the features of Discoverer Desktop to access the data. However, depending on the type of database, you may not be able to use all the data access and analysis features available with Oracle databases

            The basic process to open workbooks in the other, non-Oracle databases is essentially the same as opening a workbook in an Oracle database. Please see your Database Administrator for the correct steps to open the workbooks.

            1.3.3 Looking at a Workbook's Properties

            A workbook's properties provide basic information about the workbook.

            To see a workbook's properties:

            1. Open the workbook.

            2. Choose File | Manage Workbooks | Properties.

               The Workbook Properties dialog box appears showing information about the Workbook. You can record additional information about the workbook in the Description box.

               Figure 1-18 Workbook Properties Dialog Box

               
               
               Text description of the illustration propdb.gif

            NOTE: Identifiers are unique names that Discoverer uses to identify EUL and Workbook elements, (e.g. Business Areas, Folders, Items etc). The default Identifier value is generated automatically by Discoverer. Do not change Identifiers except under the following circumstances: The Identifier must be changed to comply with strict naming conventions. An element has been deleted and needs to be recreated with the same Identifier. If you do change an Identifier, you must update matching identifiers in other EULs to reflect the change.

            3. Click OK.

            1.3.4 Switching to Another Worksheet

            The tabs on the bottom of the workbook window show the various worksheets in the workbook. Clicking a tab switches to the next worksheet.

            The following figure shows only two tabs, but your workbook may have several worksheets--hence, more tabs.

            Figure 1-19 Switch to Another Worksheet

            
            
            Text description of the illustration 1intro4a.gif

            Key to Figure 1-19

            1. Tab scroll buttons

            2. Click these tabs to switch to another sheet in the workbook. This figure shows the worksheet named Tabular Layout is the current worksheet.

            To switch to another worksheet:

            1. Click the appropriate tab at the bottom of the workbook window. Use the scroll button if necessary to see additional worksheets. You can also use the key combinations Ctrl Pg Up and Ctrl Pg Dn to cycle through the tabs.

               If you've already opened the worksheet, clicking the tab switches to it immediately. If you haven't opened it yet, Discoverer searches the business area to find the data that belongs on the worksheet. Because each worksheet involves a query (search) of the business area, opening a worksheet for the first time takes a few moments while the search is completed. A dialog box reminds you that the search will take place.

               Figure 1-20 Open a Worksheet

               
               
               Text description of the illustration runqury.gif
            2. Click Yes to open the worksheet.

               Discoverer then estimates the time involved for the search and gives you the option to open the worksheet. Click OK to open the worksheet.

            If you decide not to open a worksheet and click Cancel, but then later click on the worksheet tab to open it, this dialog box does not appear. Choose
            Sheet | Refresh Sheet to retrieve the data.

            1.4 Saving a Workbook

            Saving a workbook saves all of its changes. You have two options:

            • To save a workbook, choose File | Save. The changes are saved and the workbook remains open.

            • To close and save a workbook at the same time, choose File | Close. If you haven't made changes to any worksheet in the workbook, it closes.

              If the workbook contains any unsaved changes on any worksheet, a dialog box reminds you to save the changes.

              Figure 1-21 Save Workbook Reminder

              
              
              Text description of the illustration closesav.gif

              Click Yes to save the changes; click No to close the workbook without saving the changes; click Cancel to keep the workbook open without saving the changes.

            To save the workbook under a different name:

            1. Choose File | Save As.

               A dialog box appears for you to specify where you want to save the renamed workbook.

               Figure 1-22 Save Workbook Dialog Box

               
               
               Text description of the illustration savewkb.gif
            2. Select an option from the Save Workbook dialog box and click Save.

               My Computer - saves the workbook locally on your computer.

               Database - saves the workbook with the database.

               • If you select My Computer, the Save As dialog box appears (Figure 1-23). Enter a new name and click Save.

               • If you select Database, the Save Workbook to Database dialog box appears and lists the workbooks already saved to the database (Figure 1-24). Enter a new name for the workbook and click Save.

                 Figure 1-23 Save As Dialog Box

                 
                 
                 Text description of the illustration saveasdb.gif

                 Figure 1-24 Save Workbook to Database Dialog Box

                 
                 
                 Text description of the illustration savetodb.gif

               1.4.1 Deleting a Workbook

               Deleting a workbook from the database permanently removes it. You should not delete a workbook from the database unless you are absolutely certain that you won't need it in the future.

               To delete a workbook from the database:

               1. Choose File | Manage Workbooks | Delete.

                  The Delete Workbook from Database dialog box appears and lists the workbooks currently in the database.

                  Figure 1-25 Delete Workbook from Database Dialog Box

                  
                  
                  Text description of the illustration delete.gif
               2. Click the name of the workbook you want to delete, then click Delete.

               1.4.1.1 Deleting a Workbook from Your Computer

               If you saved a workbook locally on your computer, deleting it removes it from your computer, but not from the database.

               To remove a workbook from your computer, use Windows Explorer or the My Computer icon to remove the workbook as you would any other file.