Overview
Main description
Generate detailed reports that will give your company the competitive edge
Put essential information in the hands of end-users across your organization using Oracle Business Intelligence Discoverer 10g and the comprehensive information contained in this Oracle Press guide. You’ll learn, step-by-step, how to query databases and warehouses, format the results, and distribute dynamic, Web-enabled reports. All features are covered in full detail, including OracleBI Discoverer Desktop, Workbook Wizard, Plus, Viewer, Discoverer Administrator, Portlet Provider, OLAP, and Enterprise Manager. Real-world case studies and tutorials illustrate all of the analysis, security, and reporting capabilities of Oracle Discoverer 10g.
- Set up, configure, and manage Oracle Business Intelligence Discoverer 10g
- Perform ad hoc and fixed queries using the Workbook Wizard
- Integrate sorts, calculations, percentages, and parameters using Discoverer Plus
- Create reports with graphs, tables, titles, headers, footers, and margins
- Use Discoverer Viewer to review, format, export, email, and print reports
- Refine queries using interactive pivoting, drilling, and Hyper Drilling
- Control OLAP workbooks using the Discoverer Catalog and Oracle Enterprise Manager
- Establish access and sharing rights, and scheduling privileges with Discoverer Administrator
- Set up and use Portal using Discoverer Portlet Provider and Portlets
- Implement query shortcuts, cascading parameters and advanced analytic calculations using templates
Table of contents
Part I - Getting Started With DiscovererChapter 1: An Overview of DiscovererChapter 2: Users and DatabasesChapter 3: Getting Started in DiscovererChapter 4: The Workbook Wizard--the Essential StepsChapter 5: The Workbook Wizard Part II--The Optional StepsPart II - Editing the QueryChapter 6: Formatting the Output in Desktop and PlusChapter 7: Using Graphs to Present DataChapter 8: Turning a Discoverer Query Into a ReportChapter 9: Using Discoverer to Analyze DataChapter 10: Using Discoverer Viewer to See Your DataPart III - Advanced Discoverer TechniquesChapter 11: Refining Items and DrillingChapter 12: Building Effective ConditionsChapter 13: Advanced Handling of Parameters, Calculations, Sorting, and PercentagesChapter 14: Query ManagementChapter 15: User Preferences, the Toolbar, and the Discoverer Administrator Chapter 16:An Introduction to Discoverer and OLAPPart IV - Using the Discoverer Administration EditionChapter 17: Getting Started in the Administration EditionChapter 18: Editing the Business AreaChapter 19: Interacting with the End UserChapter 20: Configuring DiscovererChapter 21: Setting Up Portal for Use with DiscovererChapter 22: Summary ManagementAPPENDIX A: MICHAEL'S GOLD MINE of ANSWERS TO FAQsAPPENDIX B: FUNCTIONSAPPENDIX C: DATABASES AND VIEWSAPPENDIX D: TUTORIAL DATABASE
Author comments
Michael Armstrong-Smith (Cookeville, TN) is the Principal Consultant for Armstrong-Smith Consulting. A fellow of the Institute of Analysts and Programmers, and a member of Oracle's customer advisory board on business intelligence, he has over 20 years systems development experience. Michael is a leader in the field of business intelligence, with specialist knowledge of data warehouses, and, of course, Oracle Discoverer. He is also a conference speaker and has spoken on Discoverer at conferences in Hawaii, Orlando and Toronto. Michael is the coauthor of Oracle Discoverer Handbook (Oracle Press, 2000).
Darlene Armstrong-Smith (Cookeville, TN) is Senior Curriculum Developer for Armstrong-Smith Consulting and an instructional designer and, as well as a professional trainer. She has 12 years experience designing and implementing system conversion training, and also as an adult vocational educator. Darlene has served as a training consultant to financial institutions, a national brokerage firm, a major Alaskan hotel chain and various other institutions. She has written and delivered manuals and policies and procedures for various organizations ranging from training in highly technical software to "soft skills" such as team building, employee motivation, and public speaking. Darlene is the coauthor of Oracle Discoverer Handbook (Oracle Press, 2000).
Back cover copy
Generate detailed reports that will give your company the competitive edge
Put essential information in the hands of end-users across your organization using Oracle Business Intelligence Discoverer 10g and the comprehensive information contained in this Oracle Press guide. You’ll learn, step-by-step, how to query databases and warehouses, format the results, and distribute dynamic, Web-enabled reports. All features are covered in full detail, including OracleBI Discoverer Desktop, Workbook Wizard, Plus, Viewer, Discoverer Administrator, Portlet Provider, OLAP, and Enterprise Manager. Real-world case studies and tutorials illustrate all of the analysis, security, and reporting capabilities of Oracle Discoverer 10g.
- Set up, configure, and manage Oracle Business Intelligence Discoverer 10g
- Perform ad hoc and fixed queries using the Workbook Wizard
- Integrate sorts, calculations, percentages, and parameters using Discoverer Plus
- Create reports with graphs, tables, titles, headers, footers, and margins
- Use Discoverer Viewer to review, format, export, email, and print reports
- Refine queries using interactive pivoting, drilling, and Hyper Drilling
- Control OLAP workbooks using the Discoverer Catalog and Oracle Enterprise Manager
- Establish access and sharing rights, and scheduling privileges with Discoverer Administrator
- Set up and use Portal using Discoverer Portlet Provider and Portlets
- Implement query shortcuts, cascading parameters and advanced analytic calculations using templates
