Oracle Business Intelligence: The Condensed Guide to Analysis and Reporting -- Table of Contents -- Oracle Business Intelligence: The Condensed Guide to Analysis and Reporting -- Credits -- About the Author -- About the Reviewers -- Preface -- What this book covers -- What you need for this book -- Who this book is for -- Conventions -- Reader feedback -- Customer support -- Errata -- Piracy -- Questions -- 1. Getting Business Information from Data -- Data, information, and Business Intelligence -- The kind of business questions you may need to answer -- Answering basic business questions -- Answering probing analytical questions -- Asking business questions using data-access tools -- Deriving information from existing data -- Answering business questions from your data -- Comparing and analyzing data -- Accessing transactional and dimensional data -- Reporting against a transactional database -- Using historical data -- Aggregating dimensional data -- Summary -- 2. Introducing Oracle Business Intelligence -- What Oracle Business Intelligence is comprised of -- Oracle Business Intelligence components -- Composing a Business Intelligence system -- Sitting on top of Oracle Database -- Installing Oracle Business Intelligence software -- The software you will need -- Where to get the software -- Installation process -- Installing the Oracle Business Intelligence Tools package -- Post-installation tasks -- Summary -- 3. Working with Database Data -- Using analytic SQL functions -- Answering simple questions -- Multidimensional data analysis with SQL -- Cubing -- Generating reports with only summary rows -- Ranking -- Windowing -- Accessing external sources -- Discovering SQL in Discoverer -- Relational implementation of the dimensional model -- Database structures behind an EUL -- Summary -- 4. Analyzing Data and Creating Reports.

Analyzing and reporting with Discoverer -- Preparing your working environment with Discoverer Administrator -- Exploring the Discoverer Plus IDE -- Maintaining a business-oriented view of relational data -- Analyzing data -- Using Discoverer Viewer -- Using Oracle Reports -- Starting up the Reports Server -- Building reports with Reports Builder -- Summary -- 5. Warehousing for Analysis and Reporting -- Data organization in multidimensional data sources -- Getting started with Oracle Warehouse Builder -- Installing Oracle Warehouse Builder -- Creating a Warehouse Builder repository schema -- Creating a Warehouse Builder workspace -- Building dimensional data stores with Oracle Warehouse Builder -- Launching Design Center -- Defining source metadata -- Creating a source module -- Importing database objects -- Designing target structures -- Creating a target module -- Creating dimensions -- Creating a Time dimension -- Creating a Product dimension -- Creating a Region dimension -- Creating a cube -- Building a staging table -- Creating a staging mapping -- Loading the staging table with data -- Creating mappings for loading data into dimensions -- Creating a product mapping -- Creating the REGION mapping -- Creating a cube mapping -- Deploying -- Executing -- Summary -- 6. Pivoting Through Data -- Making database data available for use in Discoverer -- Creating a crosstab worksheet in Discoverer Plus -- Pivoting worksheet items -- Creating a calculation -- Changing the worksheet layout -- Pivoting using the drag-and-drop feature -- Summary -- 7. Drilling Data Up and Down -- What is drilling? -- Drilling to a related item -- Drilling up and down -- Working with drill hierarchies -- Drilling down to see data in more detail -- Drilling up to summarize data at a higher level -- Drilling from a graph -- Using the page items area -- Summary.

8. Advanced Analysis and Reporting -- Using parameters in Discoverer -- Analyzing worksheets by entering dynamic input values -- Changing the condition behind a parameter -- Filtering a worksheet with parameters -- Conditional formatting -- Making data easier to analyze with sorting -- Summary -- Index.