Oracle Discoverer 10g Handbook

by Michael Armstrong-Smith, Darlene Armstrong-Smith

Overview

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

Product Details

ISBN-13:	9780071706865
Publisher:	McGraw Hill LLC
Publication date:	03/30/2006
Sold by:	Barnes & Noble
Format:	eBook
Pages:	1027
File size:	38 MB
Note:	This product may take a few minutes to download.

About the Author

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).

Table of Contents

Part I - Getting Started With Discoverer Chapter 1: An Overview of Discoverer Chapter 2: Users and Databases Chapter 3: Getting Started in Discoverer Chapter 4: The Workbook Wizard--the Essential Steps Chapter 5: The Workbook Wizard Part II--The Optional Steps Part II - Editing the Query Chapter 6: Formatting the Output in Desktop and Plus Chapter 7: Using Graphs to Present Data Chapter 8: Turning a Discoverer Query Into a Report Chapter 9: Using Discoverer to Analyze Data Chapter 10: Using Discoverer Viewer to See Your Data Part III - Advanced Discoverer Techniques Chapter 11: Refining Items and Drilling Chapter 12: Building Effective Conditions Chapter 13: Advanced Handling of Parameters, Calculations, Sorting, and Percentages Chapter 14: Query Management Chapter 15: User Preferences, the Toolbar, and the Discoverer Administrator Chapter 16:An Introduction to Discoverer and OLAP Part IV - Using the Discoverer Administration Edition Chapter 17: Getting Started in the Administration Edition Chapter 18: Editing the Business Area Chapter 19: Interacting with the End User Chapter 20: Configuring Discoverer Chapter 21: Setting Up Portal for Use with Discoverer Chapter 22: Summary Management APPENDIX A: MICHAEL'S GOLD MINE of ANSWERS TO FAQs APPENDIX B: FUNCTIONS APPENDIX C: DATABASES AND VIEWS APPENDIX D: TUTORIAL DATABASE