Oracle9iAS Discoverer Plus Tutorial
Version 9.0.2

Part Number A90880-01
Go To Documentation Library
Home
Go To Product List
Solution Area
Go To Table Of Contents
Contents
Go To Index
Index

Go to previous page Go to next page

5
Lesson 4: Sharing your data

It will probably take you about 30 minutes to complete this lesson.

In previous lessons, you used Discoverer to retrieve and analyze sales data. Once you have created reports, you typically want to share the reports with other Discoverer users or other organizations.

In this lesson you will learn how to use Discoverer to print and export worksheets, and share worksheets with other Discoverer users.

This lesson consists of the following exercises:

Exercise 1: Printing a worksheet

In this exercise you will learn how to print worksheet data. Discoverer provides the Print Wizard to take you step-by-step through the printing process. You will print a worksheet in the Video Tutorial Workbook to show data for the year 2000.

To print a worksheet:

  1. Connect to the Video Store Tutorial database and open the Video Tutorial Workbook.

    Hint: See Lesson 1: "Exercise 1: Starting Discoverer Plus" and "Exercise 2: Opening the tutorial workbook".

  2. Display the Tabular Layout worksheet.

    Figure 5-1 Tabular Layout worksheet in Video Tutorial Workbook workbook


    Text description of a1.gif follows.
    Text description of the illustration a1.gif

    In this example, you only want to print data for the year 2000.

    Hint: If you wanted to print data for all years available, you would select 'All' from the Year drop down list in the Page Items area, or pivot the Year item to the body of the worksheet so that data for all years was displayed on the worksheet.

  1. Choose 2000 from the Year drop down list in the Page Items area.

  2. Choose File | Print to display the Print Wizard: Select Objects dialog.

    Figure 5-2 Print Wizard: Select Objects dialog


    Text description of share1.gif follows.
    Text description of the illustration share1.gif

    The Print Wizard: Select Objects dialog enables you to select which worksheets to print. In this case, you want to print the current worksheet only.

  1. Select the Current worksheet radio button.

    Notice that the Table/Crosstab only radio button is selected by default. This is because the tutorial workbook does not contain graphs.

  2. Click Next to display the Print Wizard: Supervise dialog.

    Figure 5-3 Print Wizard: Supervise dialog


    Text description of share2.gif follows.
    Text description of the illustration share2.gif

    The Print Wizard: Supervise dialog enables you to choose whether to monitor the printing process.

    To make sure that the most current data is printed, Discoverer refreshes the worksheet before printing it to make sure that the worksheet contains up-to-date data. Sometimes issues arise during the printing process (e.g. the query used to generate the report might exceed the maximum recommended time). You can specify whether you want to resolve such issues, or whether you want Discoverer to ignore them.

  1. Select the Supervised radio button.

  2. Click Finish to send the report to the default printer.

  3. If the Windows print dialog is displayed, select the printer that you want to use from the Printer Name drop down list, then click OK.

    Figure 5-4 Windows Print dialog


    Text description of prn_nta.gif follows.
    Text description of the illustration prn_nta.gif

    In this exercise you have learned how to print worksheets in Discoverer. Now you are ready to learn how to export Discoverer worksheets to other popular application formats.

Notes:

Exercise 2: Exporting data to Microsoft Excel spreadsheet format

In this exercise you will learn how to export worksheet data to Microsoft Excel format.

You might want to share Discoverer data with people or organizations that do not have Discoverer. For example, they might have the Microsoft Excel spreadsheet package. Discoverer enables you to export worksheets in a range of commonly used application formats. Discoverer provides you with the Export Wizard to take you step-by-step through the export process. You will export a worksheet in the Video Tutorial Workbook tutorial workbook to Microsoft Excel format.

To export to Microsoft Excel format:

  1. Display the Tabular Layout worksheet if it is not already displayed.

  2. Choose File | Export to display the Export Wizard: Select Objects dialog.

    Figure 5-5 Export Wizard: Select Objects dialog


    Text description of share3.gif follows.
    Text description of the illustration share3.gif

    The Export Wizard: Select Objects dialog enables you to select which worksheets to export.

  1. Select the Current Sheet radio button.

    Notice that the Table/Crosstab only radio button is selected by default. This is because the tutorial workbook does not contain graphs.

  2. Click Next to display the Export Wizard: Define File Details dialog.

    Figure 5-6 Export Wizard: Define File Details dialog


    Text description of share4.gif follows.
    Text description of the illustration share4.gif

    The Export Wizard: Define File Details dialog enables you to select the export format and target location of the export file.

  1. Choose Microsoft Excel workbook (*.xls) from the What export format do you want? drop down list.

    Notice that you can also export to many other formats, including Text (*.txt), CSV (*.csv), and Formatted Text (*.prn).

  2. Do not change the default directory path and filename in the Where do you want to save the file? field (unless you want to save the export file in a different location).

  3. Click Next to display to the Export Wizard: Supervise dialog.

    Figure 5-7 Export Wizard: Supervise dialog


    Text description of share20.gif follows.
    Text description of the illustration share20.gif

    The Export Wizard: Supervise dialog enables you to choose whether to monitor the export process.

    To make sure that the most current data is printed, Discoverer refreshes the worksheet before printing it to make sure that the worksheet contains up-to-date data. Sometimes issues arise during the printing process (e.g. the query used to generate the report might exceed the maximum recommended time). You can specify whether you want to resolve such issues, or whether you want Discoverer to ignore them.

  1. Select the Supervised radio button.

  2. Click Finish to export the worksheet and display the Export Wizard: Export Log dialog.

    Discoverer exports the worksheet to Excel format and saves it in the location you specified.

    Figure 5-8 Export Wizard: Export Log dialog


    Text description of share5.gif follows.
    Text description of the illustration share5.gif

    The Export Wizard: Export Log dialog shows you which export files were produced and whether any issues arose during the export.

  1. (optional) If you have Microsoft Excel installed on your computer, select the Open the first exported sheet? check box.

  2. Click OK to close the Export Wizard: Export Log dialog.

    If you have Microsoft Excel installed on your computer and previously selected the Open the first exported sheet? check box, the exported worksheet is displayed in a Microsoft Excel spreadsheet.

    Figure 5-9 Discoverer worksheet exported to Microsoft Excel


    Text description of share6.gif follows.
    Text description of the illustration share6.gif

    If you did not previously select the Open the first exported sheet? check box, run the Microsoft Excel application and open the export file.

    In this exercise you have learned how to export Discoverer data to Microsoft Excel format. Now you are ready to learn how to share Discoverer worksheets with other Discoverer users.

Notes:

Exercise 3: Sharing workbooks

In this exercise you will learn how to enable other Discoverer users to access your workbooks using Discoverer Plus or Discoverer Viewer.

When you give other Discoverer users access to workbooks, you can do one of the following:

In this exercise, you will give access to all users using a public user ID called 'Public'.

  1. Choose File | Manage workbook | Sharing to display the Share workbooks dialog.

    Figure 5-11 Share Workbooks dialog


    Text description of share21.gif follows.
    Text description of the illustration share21.gif

  1. Display the User > Workbook tab.

    Figure 5-12 Share Workbooks: User > Workbook tab


    Text description of share13.gif follows.
    Text description of the illustration share13.gif

  1. Choose PUBLIC from the User drop down list

  2. To share the Video Tutorial Workbook workbook, move the Video Tutorial Workbook workbook from the Available list to the Shared list.

  3. Click OK to save the details and close the Share Workbooks dialog.

    You have now shared the Video Tutorial Workbook workbook with other Discoverer users in your organization who are part of the PUBLIC role. Every time you update the workbook, public users will get the most current version.

Lesson summary

As you can see, Discoverer provides you with a wide range of options for sharing your results with others. In this lesson you:

Tutorial summary

Congratulations on completing the tutorial!

Now that you have learnt the basic Discoverer concepts, you can use your new skills to now go on to explore Discoverer's full range of analysis tools.

Remember, if you have questions about using the product, use Discoverer's online Help and context-sensitive Help buttons.


Go to previous page Go to next page
Oracle
Copyright © 2002 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Solution Area
Go To Table Of Contents
Contents
Go To Index
Index