Oracle Discoverer 10g Handbook (Paperback)

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