This is the second edition of the Oracle Discoverer Handbook. We have greatly enhanced and updated this book to bring it up to date to the latest 10g version, 10.1.2, of Discoverer (Desktop, Plus and Viewer), and for the first time, we have covered the Administration edition. We take you through all of the steps required to build the complete end user layer used in the book.
- An Overview of Discoverer - What is it and why do you need it?
We tell you why!
- Users and Databases - We describe the responsibilities of the end user and introduce the concept of a Discoverer library.
- Getting Started in Discoverer - Who are your key users? We tell you. We also describe the main features of Discoverer and show you how to login.
- The Workbook Wizard - The essential steps, we walk you through the basics of building a workbook and teach you how to avoid writing queries from the twilight zone.
- The Workbook Wizard Part - The optional steps. We discuss the other steps, the ones that you think you need but actually don't! At least, not at first.
- Formatting the Output in Desktop and Plus - A complete description of all the formatting capabilities of Desktop and Plus.
- Using Graphs to Present Data - We show you to build graphs in both Desktop and Plus, a must read if you want to master graphing in Discoverer.
- Turning a Discoverer Query into a Report - Headers, footers, margins and all that jazz.
- Using Discoverer to analyze data - We introduce you to analysis, specifically talking about statistical, classification, deviation, trend, time and spread analysis and how to build workbooks for each.
- Discoverer Viewer - For the first time in print, a complete reference on how to use Viewer.
- Refining items - Drilling and hyper drilling we show you how to build worksheets that allow drilling and pivoting of data, Including hyper drilling.
- Building effective conditions - Simply the best description of conditions anywhere in the universe.
- Refining parameters - Calculations, sorting and percentages, dynamic parameters, cascading parameters, CASE and DECODE calculations, standard margin, manipulating dates, complex percentages, and more.
- Query management - Includes how to manage a library, third-party scheduling, the windows command line - oh yes, and let's not forget email.
- User preference, the toolbar, and the Discoverer Administrator - What do all those buttons and menus do? We tell you. Plus, just what can your administrator can do for you - a collection of 20 things that can make your life easier.
- Introducing Discoverer OLAP - Written primarily by Mark Rittman, we show you all there is to know about using OLAP with Discoverer.
- Getting started in the Administration Edition - We teach you how to build your first business area - the one used in the end user part of the book (the first 15 chapters).
- Editing the Business Area - Let us show you how to edit your business area, handle summaries, add new items and lots more.
- Interacting with the End User - A collection of some 20 workflows that describe how to handle the user requests from chapter 15.
- Configuring Discoverer - We show you how to configure your registry settings and those pesky preferences that control Plus and Viewer, plus we
explain the concept of security using a Virtual Private Database and talk
about Single Sign-On.
- Setting up a portal for use with Discoverer - Let us show you just how to set up Discoverer for use in a portal.
- Summary Management - all you would ever need to know about setting up summary tables.
- Appendix 1 Michael's Goldmine of answers to FAQs, some 60 pages of Michael's answers to your most asked questions - this will be worth the price!
- Appendix 2 Functions, if you have not seen it yet, this is simply the most complete description of every Discoverer function known to man, its syntax and lots of useful examples. We have even included a section on analytic functions and how to work with these inside discoverers.
- Appendix 3 Databases and Views, let's talk schemas - relational and star and see how Discoverer works with Oracle Applications, plus the use of Noetix Views and homegrown views. We will also tell you how to set up Discoverer against Oracle Applications and give you a few simple SQL examples.
- Appendix 4 Tutorial database, an overview of the database used throughout the book.