Oracle Discoverer 10g Handbook
1st Edition
0072262141
·
9780072262148
© 2006 | Published: March 9, 2006
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 10g and the comprehensive information contained in th…
Read More
Request Review Copy
Receive via shipping:
- Print bound version of the complete text
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
Chapter 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
Chapter 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
Part 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
Chapter 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
Chapter 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
Part 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
Chapter 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
Chapter 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
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
Chapter 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
Chapter 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
Chapter 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
APPENDIX A: MICHAEL'S GOLD MINE of ANSWERS TO FAQsAPPENDIX B: FUNCTIONSAPPENDIX C: DATABASES AND VIEWSAPPENDIX D: TUTORIAL DATABASE
APPENDIX C: DATABASES AND VIEWSAPPENDIX D: TUTORIAL DATABASE
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