| |
| |
| Acknowledgments | |
| |
| |
| Introduction | |
| |
| |
| |
| Getting Started with Discoverer | |
| |
| |
| |
| An Overview of Discoverer | |
| |
| |
| Business Intelligence and Your Organization | |
| |
| |
| Business Intelligence and Trends | |
| |
| |
| Discoverer's Role in Business Intelligence | |
| |
| |
| How to Use This Book | |
| |
| |
| A New Direction in Reporting | |
| |
| |
| Summary | |
| |
| |
| |
| Users and Databases | |
| |
| |
| What Starts Right Stays Right | |
| |
| |
| The Responsibility of the End User | |
| |
| |
| The Discoverer Library Concept | |
| |
| |
| The Report Writer Concept | |
| |
| |
| Summary | |
| |
| |
| |
| Getting Started in Discoverer | |
| |
| |
| Key Personnel | |
| |
| |
| Gaining Access to Discoverer | |
| |
| |
| Key Definitions | |
| |
| |
| Sticky Features | |
| |
| |
| Main Features of Discoverer | |
| |
| |
| Discoverer Login Sequence | |
| |
| |
| Starting a Workbook | |
| |
| |
| Summary | |
| |
| |
| |
| The Workbook Wizard: The Essential Steps | |
| |
| |
| The Workbook Wizard | |
| |
| |
| Summary | |
| |
| |
| |
| The Workbook Wizard: The Optional Steps | |
| |
| |
| The Text Area in Plus | |
| |
| |
| The Optional Steps of the Workbook Wizard | |
| |
| |
| Workbook Wizard Step 5: Creating a Sort Order (Tables Only) | |
| |
| |
| Workbook Wizard Step 6: Creating User-Defined Calculations | |
| |
| |
| Discoverer Plus Workbook Wizard Remaining Steps | |
| |
| |
| Creating User-Defined Percentages in the Plus Workbook Wizard | |
| |
| |
| Creating User-Defined Totals in the Plus Workbook Wizard | |
| |
| |
| Creating User-Defined Parameters in the Plus Workbook Wizard | |
| |
| |
| Editing the Sheet After the Query Has Run | |
| |
| |
| Summary | |
| |
| |
| |
| Editing the Query | |
| |
| |
| |
| Formatting the Output in Discoverer Desktop and Plus | |
| |
| |
| Giving Your Headings Meaningful Names (Desktop and Plus) | |
| |
| |
| Rearranging the Order of the Output | |
| |
| |
| Formatting Data | |
| |
| |
| Formatting Columns | |
| |
| |
| Deleting Columns from a Worksheet | |
| |
| |
| Formatting Totals | |
| |
| |
| Formatting Exceptions | |
| |
| |
| Adding a Title to Your Query | |
| |
| |
| Adding a Background Bitmap (Desktop Only) | |
| |
| |
| Summary | |
| |
| |
| |
| Using Graphs to Present Data | |
| |
| |
| The Available Graph Styles | |
| |
| |
| The Discoverer Desktop Graph Window | |
| |
| |
| Creating a Graph in Desktop | |
| |
| |
| Graphing in Discoverer Plus | |
| |
| |
| Modifying a Graph in Plus | |
| |
| |
| Modifying a Graph in Desktop | |
| |
| |
| Summary | |
| |
| |
| |
| Turning a Discoverer Query into a Report | |
| |
| |
| A Workflow for Building Reports | |
| |
| |
| Formatting the Report for Printing | |
| |
| |
| Page Setup | |
| |
| |
| The Sheet Tab in Desktop | |
| |
| |
| The Worksheet Tab in Plus | |
| |
| |
| Table and Crosstab Gridlines | |
| |
| |
| Inserting Page Breaks in Tables (Sorry, No Page Breaks in Crosstabs) | |
| |
| |
| Exporting Your Report to Another Application | |
| |
| |
| Summary | |
| |
| |
| |
| Using Discoverer to Analyze Data | |
| |
| |
| What Is Analysis? | |
| |
| |
| Types of Analysis | |
| |
| |
| Fundamentals of Analysis | |
| |
| |
| An Analysis Workflow | |
| |
| |
| Core Examples Used in This Chapter | |
| |
| |
| Description of the Analysis Tools Available | |
| |
| |
| The Analysis Toolbar Buttons | |
| |
| |
| How to Build the Example Queries | |
| |
| |
| Overcoming the Manager Who Is Wary of Your Analysis | |
| |
| |
| Summary | |
| |
| |
| |
| Business Intelligence Discoverer Viewer 10g Release 2 (10.1.2) | |
| |
| |
| Why Use Viewer? | |
| |
| |
| The Table or Crosstab Display Area | |
| |
| |
| Hyper-Drilling | |
| |
| |
| Graphs | |
| |
| |
| Setting Up User Preferences in Viewer | |
| |
| |
| Summary | |
| |
| |
| |
| Advanced Discover Techniques | |
| |
| |
| |
| Refining Items, Drilling, and Hyper-Drilling | |
| |
| |
| Refining Query Items | |
| |
| |
| Pivoting and Drilling | |
| |
| |
| Hyper-Drilling | |
| |
| |
| Summary | |
| |
| |
| |
| Building Effective Conditions | |
| |
| |
| Adding Conditions | |
| |
| |
| The Basic Components of a Condition | |
| |
| |
| Editing an Existing Condition | |
| |
| |
| Using Advanced Conditions | |
| |
| |
| Removing Conditions | |
| |
| |
| Removing Columns Upon Which Conditions Are Based | |
| |
| |
| Summary | |
| |
| |
| |
| Refining Parameters, Calculations, Sorting, and Percentages | |
| |
| |
| Refining Parameters | |
| |
| |
| Refining Calculations | |
| |
| |
| Refining the Sort Order | |
| |
| |
| Refining Percentages | |
| |
| |
| Summary | |
| |
| |
| |
| Query Management | |
| |
| |
| The Discoverer Manager and the End User | |
| |
| |
| Sharing Workbooks with Other Users | |
| |
| |
| Workbook Manipulation | |
| |
| |
| Worksheet Manipulation | |
| |
| |
| Scheduling Workbooks | |
| |
| |
| Running Discoverer Desktop from the Command Line | |
| |
| |
| SQL Management | |
| |
| |
| E-Mailing Worksheets and Reports | |
| |
| |
| Summary | |
| |
| |
| |
| User Preferences, the Toolbar, and the Discoverer Administrator | |
| |
| |
| Customizing User Preferences | |
| |
| |
| Desktop Options | |
| |
| |
| Plus Options | |
| |
| |
| The Toolbar | |
| |
| |
| The Discoverer Administrator | |
| |
| |
| Summary | |
| |
| |
| |
| Introducing Discoverer OLAP | |
| |
| |
| OLAP Background | |
| |
| |
| Oracle Business Intelligence Discoverer Plus for OLAP | |
| |
| |
| About the Examples | |
| |
| |
| The Global Widgets Logical Dimensional Model | |
| |
| |
| Connecting to Discoverer Plus for OLAP | |
| |
| |
| Creating Your First OLAP Plus Workbook | |
| |
| |
| Exploring the Discoverer Plus for OLAP User Interface | |
| |
| |
| Using the Workbook Wizard to Create OLAP Workbooks | |
| |
| |
| Summary | |
| |
| |
| |
| Using the Discoverer Administration Edition | |
| |
| |
| |
| Getting Started in the Administration Edition | |
| |
| |
| Key Definitions | |
| |
| |
| Sticky Features | |
| |
| |
| The Steps to a Successful Discoverer Implementation | |
| |
| |
| Source to Destination | |
| |
| |
| Creating the End User Layer | |
| |
| |
| Creating Your First Business Area | |
| |
| |
| Key Business Area Objects | |
| |
| |
| Checking a Business Area | |
| |
| |
| Summary | |
| |
| |
| |
| Editing the Business Area | |
| |
| |
| Remaining Business Area Checks | |
| |
| |
| Enhancing Business Areas | |
| |
| |
| Summary | |
| |
| |
| |
| Interacting with the End User | |
| |
| |
| Adding New Users | |
| |
| |
| Granting Access to Business Areas | |
| |
| |
| Granting User Edition Privileges | |
| |
| |
| Adding Meaningful Descriptions to Business Areas, Folders, and Data Items | |
| |
| |
| Adding New Items to Folders | |
| |
| |
| Creating New Folders | |
| |
| |
| Creating Joins Between Folders | |
| |
| |
| Creating Lists of Values | |
| |
| |
| Creating Alternative Sorts | |
| |
| |
| Creating New Items Based on Calculations | |
| |
| |
| Creating New Conditions | |
| |
| |
| Creating Drill Hierarchies | |
| |
| |
| Modifying an Item's Type | |
| |
| |
| Creating Summary Data | |
| |
| |
| Rearranging the Order of Folders in a Business Area | |
| |
| |
| Rearranging the Order of Items in a Folder | |
| |
| |
| Changing Refresh Cycles | |
| |
| |
| Allowing Scheduling of Workbooks | |
| |
| |
| Creation of New Functions | |
| |
| |
| Summary | |
| |
| |
| |
| Configuring Discoverer | |
| |
| |
| Architecture | |
| |
| |
| Oracle HTTP Server (OHS) | |
| |
| |
| Oracle Containers for J2EE (OC4J) | |
| |
| |
| OEM Application Server Control | |
| |
| |
| Configuring Discoverer Using OEM | |
| |
| |
| Single Sign-On (SSO) | |
| |
| |
| OPMN (Oracle Process Management and Notification) | |
| |
| |
| Oracle Internet Directory (OID) | |
| |
| |
| Metadata Repository | |
| |
| |
| Discoverer Preferences | |
| |
| |
| Web Cache | |
| |
| |
| Summary | |
| |
| |
| |
| Setting Up Portal for Use with Discoverer | |
| |
| |
| Using Portal | |
| |
| |
| Configuring the Discoverer Server | |
| |
| |
| Portal Administration | |
| |
| |
| Working with Portlets | |
| |
| |
| Summary | |
| |
| |
| |
| Summary Management | |
| |
| |
| Background | |
| |
| |
| Summary Setup | |
| |
| |
| Materialized Views | |
| |
| |
| Managing Summary Tables | |
| |
| |
| Summary Combination Strategy | |
| |
| |
| Using Summary Tables with Oracle Applications | |
| |
| |
| End-User Options | |
| |
| |
| Summary | |
| |
| |
| |
| Appendixes | |
| |
| |
| |
| Michael's Gold Mine of Answers to FAQs | |
| |
| |
| |
| SQL Functions | |
| |
| |
| Standards Used in the Listing | |
| |
| |
| Wildcards | |
| |
| |
| Folders in Discoverer | |
| |
| |
| Alphabetical Listing of Functions | |
| |
| |
| Time Zones | |
| |
| |
| Using Formats When Rounding Dates | |
| |
| |
| Date Format Masks | |
| |
| |
| Number Format Masks | |
| |
| |
| ASCII Character Set | |
| |
| |
| Analytic Functions | |
| |
| |
| Summary | |
| |
| |
| |
| Databases and Views | |
| |
| |
| Database Schemas | |
| |
| |
| Accessing Oracle Applications Using Discoverer | |
| |
| |
| Summary | |
| |
| |
| |
| Tutorial Database | |
| |
| |
| Entity-Relationship Diagram for the Global Widgets Sales Database | |
| |
| |
| The Global Widgets Tables | |
| |
| |
| Entity-Relationship Diagram for the Fan Trap | |
| |
| |
| The Fan Trap Tables | |
| |
| |
| Summary | |
| |
| |
| Index | |