1 / 9

Oracle Discoverer an overview

Oracle Discoverer an overview. Brett Ford Feb 11, 2004 NorCal OAUG. What is Oracle Discoverer?. A relatively user-friendly reporting tool for retrieving data from Oracle databases Can be used for both “ad hoc” and “pre-defined” reports Useful reporting tool for both casual and power users

raymond
Download Presentation

Oracle Discoverer an overview

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Oracle Discovereran overview Brett Ford Feb 11, 2004 NorCal OAUG

  2. What is Oracle Discoverer? • A relatively user-friendly reporting tool for retrieving data from Oracle databases • Can be used for both “ad hoc” and “pre-defined” reports • Useful reporting tool for both casual and power users • Integrated with Oracle E-Business Suite

  3. Discoverer Reports(Common Usage) • Casual users can view pre-defined reports • Power users/analysts can create “ad hoc” reports • IT Business Analysts or Developers create “pre-defined” reports

  4. Ease of Use • Viewing pre-defined reports  Very Easy! • Creating ad hoc reports  Easy but problematic • Creating pre-defined reports  Moderate difficulty • Basic data formatting options (font size, summation, breakpoints, graphs, etc)

  5. Security/Administration • Oracle Discoverer does require a system administrator to maintain an End User Layer (EUL) • Security is administered via the EUL • Business Folders (tables and views) are assigned to Business Areas (major groupings of Business Folders) • Users/Responsibilities are granted access to Business Areas

  6. Security/Admin Cont’d • EUL can be created in “apps mode” to automatically integrate Oracle Application users and responsibilities • Pre-Defined Reports can be stored in the database and secured by the creating user • Creating user has the option to “share” pre-defined reports with other users • Can secure which users are allowed to save reports to database

  7. “Out of the Box Integration” • User/Responsibility integration with Oracle E-Business Suite (apps mode EUL) • Business View Generator customizes business views for Key and Descriptive Flexfield definitions. • Auto-Creation of Business Areas and Folders from Business Views (BIS) • Discoverer Web Reports can be run from personal homepage in release 11i

  8. Some Product Drawbacks • Users cannot set table/view linkages  must be performed by EUL admin • Multiple table linkages can cause “fan trap” problems • New reports often require creation of new database view • Limit on number of rows retrieved (16,000) • Formatting and printing options are very basic

  9. For Additional Information… Oracle Technology Network http://otn.oracle.com/products/discoverer AppsNet http://www.oracle.com/appsnet/technology/bi E-mail fordbw@excite.com

More Related