1 / 46

Richard Byrom

Richard Byrom. Consultant RPC Data 9 th June 2002. Discoverer Overview. Presentation Purpose. Provide you with an understanding of what Oracle Discover is and what it is capable of. Demonstrate the capabilities of the product on a test system. What is Discoverer?.

rhoslyn
Download Presentation

Richard Byrom

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. Richard Byrom Consultant RPC Data 9th June 2002

  2. Discoverer Overview

  3. Presentation Purpose • Provide you with an understanding of what Oracle Discover is and what it is capable of. • Demonstrate the capabilities of the product on a test system.

  4. What is Discoverer? Market leading end-user ad hoc query, analysis and reporting tool that is also web enabled.

  5. What does it do? • Enables users at any level in an organization to gain rapid access to information stored in their transactional databases, data warehouses or data marts. • Provides powerful navigation and analytical capabilities such as pivoting, drilling, aggregations and calculations. • In an Oracle Applications environment, it provides and intuitive way for non technical end users (like execs and business analysts) to get rapid answers to business questions.

  6. Discoverer Strengths • Ease of Use • Analytical Power • Scalability and Performance • Ease of Administration • Integration and Customization

  7. Ease of Use

  8. cl_addr1||','|| cl_addr2|','|| cl_addr3||', '|| cl_twn||', '|| cl_zipcode sum(nvl(qty* unit_price,0)) Business View of Database InformationHiding the complexity Database User’s View

  9. One Click Operations • Wizard Driven • Tutorials • Reduced Learning Curve Drag & Drop Layout Interactive Dialogs Strong Focus on Customer Usability

  10. Single User Interface Discoverer for Windows Discoverer 3i User Edition Discoverer 3i Viewer Desktop Edition (c/s) Plus (java) Viewer (HTML)

  11. Drill Everywhere Europe • Drill Down France Paris

  12. Europe France • Drill Out Paris External Data Drill Everywhere • Drill Down

  13. Analytic Power

  14. Power and Simplicity You Demand Answers to Analytical Questions • “What are my top ten products...” • “What is the 3 month moving average ...” • “What is the cumulative sum of my sales by Region...” • “What is the ranking of my sales this year compared to sales last year?”

  15. Analytical Power at your fingertips !... • Calculator functions (+ - * / ) • Intelligent (Sub)Totals & Percentages • SQL functions: Financial, Arithmetic, Logical, Analytic • Enhanced Data Aggregation • Custom functions - PL/SQL registered • Leverage Analytical Calculations: use with Conditions, Sort, Pivot and nesting

  16. Empower your users Ratios Rank Subtotals

  17. Nesting Analytic Power Nested Calculations: 1 sales yr ago : lag(sales, 4) 2 growth : sales yr ago/sales this yr 3 rank growth : rank(growth)

  18. Performance & Scalability

  19. internet Discoverer Architecture Clients ApplicationServer(s) DatabaseServer(s) DMZ Oracle9i Application Server Oracle9i Application Server Oracle9i Web Cache EUL Metadata Database Oracle9i Application Server Internet users Metadata in DB Firewall Support Load Balancing Multiple Servers

  20. EUL Cubic Client CachePerformance Client • Re-using cache • OLAP type access • Rapid drill & rotate Oracle9i Application Server Discoverer Services Client Session Database

  21. ? EUL Cubic Client CachePerformance Client • Re-using cache • OLAP type access • Rapid drill & rotate • Incremental Drill Oracle9i Application Server Discoverer Services Client Session Database

  22. Predicts time a query takes before execution • Does not waste valuable resources! Advanced Query Prediction Performance Reactive Query Governor • Stops queries after a pre-set time • Uses the resources without showing results! Predictive Query Governor

  23. Batch Scheduling • Wizard Driven • User friendly scheduling • Easy management • Automatic notice when result set is ready or to expire

  24. Select Store, Period, Product, sum(video_sales) From video_details Group by Store, Period, Product • Slow Table Scans • Machine Intensive Aggregation Summary Redirection Detail Rows Summary Table

  25. Select Store, Period, Product, Sales Fromvideo_summary Summary Redirection Automatic!! Detail Rows Summary Table

  26. Ease of Administration

  27. Discoverer AdministratorEasy End User Layer Management Easy Administration Bulk Load Wizard EUL Management Wizard Tutorial Installation • Oracle9i Discoverer Administrator • Populate Business Area • Hierarchies • Joins • Default Aggregates • LOVs • Create/Delete EULs • Sample schema and EUL for • training

  28. Administrative Reporting • Which Folders are users querying most? Which Items? • Where are my long running queries? • Who owns what workbooks? When were they last used? • What are my users privileges?

  29. Application Application Application Application Browser Java Oracle9iAS Discoverer Services Browser Simplified Deployment Application Application X Application Database Application

  30. Reports Metadata Reports Metadata Reports Metadata Reports Metadata Database Oracle9iAS Discoverer Services Centralized Metadata Reports X Metadata

  31. DiscovererAutomated Summary Management Evolutionary solution for optimizing query performance! • Discoverer Summary Wizard • recommends summary policies, • create summary tables with a single click, • allow users to view and fine tune policies as needed.

  32. DiscovererAutomated Summary Management : automated - summary policies : don’t need to be a DBA : the algorithm - tune for different policies : performance gain estimate • 100% • Easy to use • Customize • Graphical

  33. Customization & Integration

  34. Discoverer Viewer Custom Look and Feel Custom Standard

  35. Complete and Integrated BI • Oracle9iAS OEM • Oracle9iAS Reports • Oracle9iAS Portal • Oracle9iAS Web Cache • Oracle Single Sign On Server • Oracle Internet Directory • Oracle9i Warehouse Builder • Oracle e-Business Suite

  36. Discoverer integration with Portal Worksheet Portlet: Graph Worksheet Portlet: Crosstab List of Workbooks Portlet

  37. Discoverer EUL Business Views Logical Data Model Application Product Tables Oracle e-Business Suite Business Intelligence Solution Query/Reporting Tools Financial Applications OLAP Applications Business Intelligence System Manufacturing Applications

  38. “Out of the Box” Oracle e-Business Suite Integration • Native Oracle Application Security • Respecting 100% Apps user accounts /responsibilities • No extra setup • The same level of multi-org access control • Reporting on cross organizations w/ users Apps grants • Applications Key and Descriptive Flexfields • Reporting on full apps data inc. customized flexfields

  39. Meeting Requirements... Requirements Ease of Use Analytic Power Central Administration & Security Integration Customization Price Oracle9iAS Discoverer Single UI Instant Web Deployment Free SQL Analytics Centralized Metadata Single Sign On (SSO) Database, OWB, Reports, Portal, Web Cache, SSO, e-Business Suite XSL Style Sheet 4 Times Less

  40. Benefits... Benefits Empowered Users Reduced Administrative Costs Reduced Deployment Costs Reduced IT Dependency Competitive Advantage Better Decision Making Oracle9iAS Discoverer Yes Yes Yes Yes Yes Yes

  41. Demonstration - Query Description of how to build an end user layer specific to user requirements and security specifications – different views for different people

  42. Demonstration - Analysis • Tables, page detail reports and cross tabs • Show the use of conditions, exceptions and calculations and drag and drop • Show a graph with a drill through

  43. Demonstration - Reporting Show how you can export the data to excel and express

  44. Q & Q U E S T I O N S A N S W E R S A

More Related