LEADER 05119nam 2200649 a 450 001 9910785350403321 005 20200520144314.0 010 $a1-282-88220-1 010 $a9786612882203 010 $a1-84968-119-8 035 $a(CKB)2670000000055944 035 $a(EBL)944000 035 $a(OCoLC)796383604 035 $a(SSID)ssj0000519317 035 $a(PQKBManifestationID)11375356 035 $a(PQKBTitleCode)TC0000519317 035 $a(PQKBWorkID)10497830 035 $a(PQKB)11635617 035 $a(MiAaPQ)EBC944000 035 $a(Au-PeEL)EBL944000 035 $a(CaPaEBR)ebr10428650 035 $a(CaONFJC)MIL288220 035 $a(PPN)228010918 035 $a(EXLCZ)992670000000055944 100 $a20101206d2010 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aOracle Business Intelligence$b[electronic resource] $ethe condensed guide to analysis and reporting /$fYuli Vasiliev 210 $aBirmingham [England] $cPackt Pub.$d2010 215 $a1 online resource (184 p.) 225 0 $aEnterprise : professional expertise distilled 300 $aIncludes index. 300 $a"A fast track guide to uncovering the analytical power of Oracle Business Intelligence : Analytic SQL, Oracle Discoverer, Oracle Reports, and Oracle Warehouse Builder." 311 $a1-84968-118-X 327 $aCover; Copyright; Credits; About the Author; About the Reviewers; Table of Contents; Preface; Chapter 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 327 $aUsing historical dataAggregating dimensional data; Summary; Chapter 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; Chapter 3: Working with Database Data; Using analytic SQL functions; Answering simple questions 327 $aMultidimensional data analysis with SQLCubing; 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; Chapter 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 327 $aStarting up the Reports ServerBuilding reports with Reports Builder; Summary; Chapter 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 327 $aCreating a cubeBuilding 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; Chapter 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; Chapter 7: Drilling Data Up and Down; What is drilling? 327 $aDrilling to a related item 330 $aA fast track guide to uncovering the analytical power of Oracle Business Intelligence: Analytic SQL, Oracle Discoverer, Oracle Reports, and Oracle Warehouse Builder with this book and eBook 606 $aBusiness$xData processing 606 $aBusiness report writing$xData processing 615 0$aBusiness$xData processing. 615 0$aBusiness report writing$xData processing. 676 $a005.7565 700 $aVailiev$b Yuli$01516792 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910785350403321 996 $aOracle Business Intelligence$93753479 997 $aUNINA