Oracle Discoverer 10g Handbook - Brossura

Armstrong-Smith, Michael; Armstrong-Smith, Darlene

Brossura

ISBN 10: 0072262141 ISBN 13: 9780072262148

Casa editrice: McGraw Hill, 2006

Riassunto

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

Su questo libro

L'autore

Michael Armstrong-Smith (Fremont, CA) is a Software Consultant and Technical Trainer with a specialist knowledge of Oracle Applications Data Warehouse, Discoverer, Electron Data Interchange, Software Production, Distributed Systems Design, Database Administration and System Analysis.

Contenuti

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

Dettagli dell?edizione

• Editore: McGraw Hill
• Data di pubblicazione: 2006
• ISBN 10: 0072262141
• ISBN 13: 9780072262148
• Rilegatura: Copertina flessibile
• Lingua: Inglese
• Numero di pagine: 1027