Oracle Discoverer 10g Handbook

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

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