Oracle Discoverer 10g Handbook

by Armstrong-Smith, Michael; Armstrong-Smith, Darlene

• ISBN13: 9780072262148
• ISBN10: 0072262141
• Edition: 1st
• Format: Paperback
• Copyright: 2006-03-30
• Publisher: McGraw-Hill Education

Summary

Generate detailed reports that will give your company the competitive edgePut essential information in the hands of end-users across your organization using Oracle Business Intelligence Discoverer 10gand 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

Author Biography

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