Sumário Itens Encontrados: 103Preface 1Chapter 1: Getting Business Information from Data 7Data, information, and Business Intelligence 8The kind of business questions you may need to answer 10Answering basic business questions 10Answering probing analytical questions 11Asking business questions using data-access tools 12Deriving information from existing data 15Answering business questions from your data 16Comparing and analyzing data 18Accessing transactional and dimensional data 20Reporting against a transactional database 21Using historical data 21Aggregating dimensional data 22Summary 23Chapter 2: Introducing Oracle Business Intelligence 25What Oracle Business Intelligence is comprised of 26Oracle Business Intelligence components 26Composing a Business Intelligence system 27Sitting on top of Oracle Database 30Installing Oracle Business Intelligence software 31The software you will need 31Where to get the software 33Installation process 34Installing the Oracle Business Intelligence Tools package 41Post-installation tasks 43Summary 48Chapter 3: Working with Database Data 49Using analytic SQL functions 49Answering simple questions 50Multidimensional data analysis with SQL 50Cubing 54Generating reports with only summary rows 57Ranking 58Windowing 60Accessing external sources 61Discovering SQL in Discoverer 63Relational implementation of the dimensional model 64Database structures behind an EUL 64Summary 67Chapter 4: Analyzing Data and Creating Reports 69Analyzing and reporting with Discoverer 69Preparing your working environment with Discoverer Administrator 70Exploring the Discoverer Plus IDE 75Maintaining a business-oriented view of relational data 82Analyzing data 85Using Discoverer Viewer 88Using Oracle Reports 91Starting up the Reports Server 91Building reports with Reports Builder 93Summary 98Chapter 5: Warehousing for Analysis and Reporting 99Data organization in multidimensional data sources 100Getting started with Oracle Warehouse Builder 100Installing Oracle Warehouse Builder 101Creating a Warehouse Builder repository schema 103Creating a Warehouse Builder workspace 104Building dimensional data stores with Oracle Warehouse Builder 108Launching Design Center 108Defining source metadata 110Creating a source module 110Importing database objects 112Designing target structures 115Creating a target module 115Creating dimensions 117Creating a cube 120Building a staging table 121Creating a staging mapping 122Loading the staging table with data 128Creating mappings for loading data into dimensions 129Creating a product mapping 129Creating the REGION mapping 130Creating a cube mapping 130Deploying 131Executing 132Summary 132Chapter 6: Pivoting Through Data 133Making database data available for use in Discoverer 133Creating a crosstab worksheet in Discoverer Plus 136Pivoting worksheet items 138Creating a calculation 138Changing the worksheet layout 139Pivoting using the drag-and-drop feature 142Summary 144Chapter 7: Drilling Data Up and Down 145What is drilling? 145Drilling to a related item 146Drilling up and down 149Working with drill hierarchies 150Drilling down to see data in more detail 151Drilling up to summarize data at a higher level 152Drilling from a graph 153Using the page items area 156Summary 156Chapter 8: Advanced Analysis and Reporting 157Using parameters in Discoverer 157Analyzing worksheets by entering dynamic input values 158Changing the condition behind a parameter 160Filtering a worksheet with parameters 161Conditional formatting 163Making data easier to analyze with sorting 166Summary 166Index 167