LEADER 05128nam 2200733Ia 450 001 9910456260603321 005 20200520144314.0 010 $a1-282-17235-2 010 $a1-84719-687-X 010 $a9786612172359 035 $a(CKB)2430000000040715 035 $a(EBL)956358 035 $a(OCoLC)697738948 035 $a(SSID)ssj0000349332 035 $a(PQKBManifestationID)12084538 035 $a(PQKBTitleCode)TC0000349332 035 $a(PQKBWorkID)10348899 035 $a(PQKB)11454618 035 $a(MiAaPQ)EBC956358 035 $a(CaSebORM)9781847196866 035 $a(PPN)227992989 035 $a(Au-PeEL)EBL956358 035 $a(CaPaEBR)ebr10433549 035 $a(CaONFJC)MIL217235 035 $a(EXLCZ)992430000000040715 100 $a20090827d2009 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aOracle Essbase 9 implementation guide$b[electronic resource] $edevelop high-performance multidimensional analytic OLAP solutions with Oracle Essbase /$fSarma Anantapantula, Joseph Sydney Gomez 205 $a1st edition 210 $aBirmingham, U.K. $cPackt Publishing Ltd.$d2009 215 $a1 online resource (444 p.) 225 1 $aFrom technologies to solutions 300 $aIncludes index. 311 $a1-84719-686-1 327 $aCover; Table of Contents; Preface; Chapter 1: Installing Oracle Essbase; Installing the Essbase analytic server; Installing Essbase Administration Services; Starting the EAS; Installing the Essbase Add-in for Microsoft Excel; A typical network setup; Summary; Chapter 2: Essbase Data and Design Considerations; Introduction to OLAP; Determining the data requirements; Determine data storage options; Types of Essbase applications; Aggregate Storage Option (ASO); Block Storage Option (BSO); Unicode and Non-Unicode applications; Creating your first Essbase application 327 $aEssbase Application PropertiesStartup section; Security; Minimum access level; Types of Essbase databases; The normal (non-currency) database; Essbase currency database; Database components; The database outline; Linked Reporting Objects; Partitions; Calculation scripts; Report scripts; Database load rules files; Allowing duplicate member names; Create your first Essbase database; General tab; Dimensions tab; Statistics tab; Caches tab; Transactions tab; Storage tab; Currency tab; Modifications tab; Types of Essbase users; Summary; Chapter 3: Building the Essbase Outline; Before we begin 327 $aThe Essbase outline-the foundationDimensions and members; Outline member descriptors; Generations and Levels; Generation; Level; Types of dimensions; Standard dimension; The Account dimension type; The Time dimension type; The Country dimension type; No dimension type or general dimension; The Currency Partition dimension type; The Attribute dimension; Dense and Sparse dimensions; Build your first outline; Member properties; Member consolidations; Valid consolidation operators; Member storage; Member formulas; Member alias; Alias table; Build your first data rules file 327 $aStep 1: Start the Data Prep EditorStep 2: Associate the Dimension Build Rules file; Step 3: Open data load file or the SQL data source file; Step 4: Set the Data Source Properties; Step 5: Set the View to Dimension build fields; Step 6: Select Dimension build method; Generation reference; Level reference; Parent-child reference; Step 7: Format file; Step 8: Associate fields with dimensions; Step 9: Validate the Dimension Build rules file; Update your outline using a rules file; Update your outline using the EAS Outline Editor; Update using MaxL Shell; Executing MaxL from EAS editor 327 $aExecuting MaxL from command promptAttribute dimensions; User Defined Attributes (UDA); Dynamic Time Series; Shared members; Summary; Chapter 4: Loading Data into Essbase; Make your data Essbase-friendly; Essbase-friendly thoughts; Essbase-friendly example; Types of data sources; Type of data; Types of files used for data loads; Relational databases; Data load methods; Data file freeform (no load rule); Essbase export and import (no load rule); Structured data load (load rule used); Microsoft Excel Lock and Send (no load rule); Building your first data load rules file 327 $aStep 1: Starting the Data Prep Editor 330 $aDevelop high-performance multidimensional analytic OLAP solutions with Oracle Essbase 9 with this book and eBook 606 $aClient/server computing 606 $aDatabase design 606 $aOLAP technology 606 $aSystem design 608 $aElectronic books. 615 0$aClient/server computing. 615 0$aDatabase design. 615 0$aOLAP technology. 615 0$aSystem design. 676 $a005.36 700 $aAnantapantula$b Sarma$0860068 701 $aGomez$b Joseph Sydney$0860069 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910456260603321 996 $aOracle Essbase 9 implementation guide$91919075 997 $aUNINA