Discoverer 2000 Vs Oracle Reports V2

Comparative Evaluation Between Discoverer & Oracle Reports

Slide 1

Agend aDiscoverer - Overview   Advantages over D2K Reports  Disadvantages over D2K Reports

Slide 2

Overview

Slide 3

Overview OracleAS Discoverer offers web based decision support capabilities to end-users and is an integral element of a comprehensive business intelligence solution provided by Oracle Application Server.

Slide 4

Overview Discoverer is an intuitive ad-hoc querying, reporting, analysis, and web-publishing tool. It provides business users with immediate access to information from data marts, data warehouses, online transaction systems, and Oracle Applications.

Slide 5

Overview Discoverer allows both novice and experienced users to create queries, navigate through data, and publish report results. Discoverer can be deployed in either a scalable web architecture or client/server architecture or a combination of both. It has six components: Discoverer Plus, Discoverer Viewer, Discoverer Administrator, Discoverer Portlet Provider, the Discoverer End User Layer, and Slide 6

Overview Formatting: Font, size, alignment, color – foreground and background, display names and format masks – numeric, monetary, date, etc… can be applied to report elements in Discoverer Plus. Format modifications are independent of the platform. Changes applied in Discoverer Plus are visible in the Discoverer Desktop and vice versa. This formatting is preserved when uses view these reports in Discoverer Viewer or in a portal page. Slide 7

Overview Graphs: End users can create graphs in Discoverer with an easy to use wizard that supports more than 50 different standard and custom graph types. Users can add graph titles, resize, format styles, colors and much more to create ‘boardroom quality’ graphs, or to conform to corporate standards.

Slide 8

Overview Analytic calculation templates available in Discoverer Plus: Users can use the following analytic calculation templates to get quick insights into their data - Rank - Percent Rank - Difference - Percent Difference - Preceding Value Slide 9

Overview - Following Value - Running Total - Percent Running Contribution - Percent Contribution - Moving Total - Group Total - Band By Value - Band By Rank

Slide 10

Overview Scheduling Discoverer provides advanced scheduling capabilities. Users can schedule workbooks using a wizard based user interface, specify and maintain a 'repeat' interval, choose to keep either all results sets or just the latest version. Discoverer suggests users to schedule workbooks when their query prediction threshold is exceeded. Discoverer automatically notifies users when scheduled workbooks are available or when expired result sets are to be removed. Slide 11

Overview

Administration When number of users increased: Discoverer is built using a stable ‘n-tier’ distributed component architecture. Components of Discoverer Services can be added dynamically to meet increased demand as the number of concurrent users increases. It uses a configurable round robin method to balance the load across all available Discoverer Services. No administrator intervention is required

Slide 12

Overview Performance when number of users increased: Discoverer is optimized for performance and designed to minimize network traffic. Performance options include HTML paging, client side timeouts and zero software download. Discoverer Viewer breaks large documents into pages in the background and displays the first page initially.

Slide 13

Overview Performance when number of users increased: Discoverer Services monitors client activity and end inactive sessions after a specified timeout limit. This frees up valuable resources for other users.

Slide 14

Overview Licenses (Purchasing): You need to purchase the following Oracle products in order to receive Discoverer: · Oracle Application ServerTM Enterprise Edition for Discoverer Plus and Viewer. · Oracle Developer SuiteTM for Discoverer Administrator including 1 user license of Discoverer Desktop Edition. Slide 15

Overview Licenses (Purchasing): Oracle Discoverer Desktop Edition can be purchased as a stand alone product for additional licenses. Price : Discoverer Desk top Edition – Named User Plus Perpetual ($1,000.00)

Slide 16

Overview Discoverer Can Export data to Oracle Reports: Discoverer provides seamless integration with Oracle Reports Developer, the enterprisereporting tool. Discoverer users can export workbooks with full fidelity. This provides users access to the full suite of publishing capabilities of Oracle Reports Services, such as batch scheduling and PDF support. Slide 17

Overview Revenue Strategic Report (Screen Layout):

Slide 18

Advantage of Discoverer Introduction Over Oracle Dev. Reports

Slide 19

Advantage of Discoverer over Oracle Reports

Effort Oracle Discoverer

Oracle Reports

Effort in Development is lesser Very easy to modify the Worksheet

Effort is significantly more in Development Change in Layout is a significant effort

Slide 20

Advantage of Discoverer over Oracle Reports

Flexibility Oracle Discoverer

Oracle Reports

Analytical Functions like Rank, Running Totals, Statistical Functions are available “Out-of-the Box” to be used by Users in a dynamic fashion

This feature is not available dynamically

Slide 21

Advantage of Discoverer over Oracle Reports

Flexibility Oracle Discoverer Users can Sort by any Item in the Work-sheet. This can be changed effortlessly by User at Run-time.

Oracle Reports Sorting can be provided, but at the time of Report creation by the developer

Slide 22

Disadvantage of Discoverer Over Oracle Dev. Reports

Slide 23

Disadvantage of Discoverer 2000

Initial Efforts Oracle Discoverer Meta data needs to be created by Oracle technical consultants

Oracle Reports No need to create Meta data

Slide 24

Disadvantage of Discoverer 2000

Flexibility Oracle Discoverer Can not create multiple graphs in one sheet

Oracle Reports Can create multiple graphs in one sheet

Slide 25

Disadvantage of Discoverer 2000

Discoverer Components Discoverer Plus : Ad hoc query creation, advanced analysis, navigation and charting Discoverer Viewer : Powerful analysis and easy navigation for casual users to view reports Discoverer Portlet Provider : Publishing existing Discoverer workbooks to OracleAS Portal Slide 26

Disadvantage of Discoverer 2000

Oracle Developer Suite includes: Discoverer Administrator : Creating and maintaining a business view of the data and access control Discoverer End User Layer : Discoverer’s metadata repository stored in the database Discoverer Desktop : Ad hoc query creation, advanced analysis (client/server version) End of Presentation Slide 27