LEADER 05356nam 2200661 a 450 001 9910823869203321 005 20240516181838.0 010 $a1-283-45346-0 010 $a9786613453464 010 $a1-84968-327-1 035 $a(CKB)2550000000087698 035 $a(EBL)943412 035 $a(OCoLC)796384666 035 $a(SSID)ssj0000647041 035 $a(PQKBManifestationID)11383131 035 $a(PQKBTitleCode)TC0000647041 035 $a(PQKBWorkID)10593288 035 $a(PQKB)10068348 035 $a(Au-PeEL)EBL943412 035 $a(CaPaEBR)ebr10529555 035 $a(CaONFJC)MIL345346 035 $a(PPN)228040655 035 $a(FR-PaCSA)88850651 035 $a(MiAaPQ)EBC943412 035 $a(EXLCZ)992550000000087698 100 $a20120303d2012 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aOracle Essbase 11 development cookbook $eover 90 advanced development recipes to build and take your Oracle Essbase applications further /$fJose R. Ruiz 205 $a1st ed. 210 $aBirmingham, U.K. $cPackt Enterprise$d2012 215 $a1 online resource (400 p.) 300 $a"Quick answers to common problems"--Cover. 300 $aIncludes index. 311 $a1-84968-326-3 327 $aCover; Copyright; Credits; About the Author; About the Reviewer; www.PacktPub.com; Table of Contents; Preface; Chapter 1:Understanding and Modifying Data Sources; Introduction; Setting up an Account or Measure dimension with a parent-child reference; Setting up dimensions with a generation reference; Adding columns for outline formulas; Adding the solve order column to tables that have ASO formulas; Adding and populating the Sort Order Column; Adding tables for varying attributes; Determining hierarchies in relational tables; Using the Essbase Outline Extractor to extract dimensions 327 $aUsing Star Analytics to build your star schema from existing Essbase cubesChapter 2:Using Essbase Studio; Introduction; Creating TBC sample database and connecting to the data source; Adding user-defined tables; Building your minischema; Setting up joins in a minischema; Adding tables to a minischema; Using a text file data source; Working with Common Platform Language (CPL); Using Sort Order on data elements; Chapter 3: Building theBSO Cube; Introduction; Creating hierarchies using a parent-child reference table; Creating hierarchies using a generation reference table 327 $aAdding attribute dimensions to hierarchiesBuilding a Calendar dimension; Creating date elements; Creating Alias tables; Developing cube schema and an Essbase model; Setting Essbase properties; Deploying a cube; Creating an OLAP Model in EIS; Creating an OLAP metaoutline in EIS; Chapter 4:Building the ASO Cube; Introduction; Using the Connection Wizard to set up an ASO cube; Building a Measures dimension from the fact table; Creating an ASO Cube Schema and an Essbase Model; Understanding Essbase Model properties for the ASO cube; Designing a drill-through report 327 $aUsing the View dimension for Dynamic Time Series reportingChapter 5:Using EAS for Development; Introduction; Adding an application and database on an Essbase Server; Using the outline editor to add dimensions; Using dimension build rules to add the parent-child dimension; Creating dimension build rules to add a base and attribute dimensions; Using dimension build rules to add user-defined attributes and associate dimensions; Creating load rules for flat file data loads; Creating substitution variables; Using If/Else logic and substitution variables in outline formulas 327 $aUsing Text measures on a BSO cubeUsing Date measures on a BSO cube; Using different outline formula logic at parent level; Creating a load rule for SQL data load using substitution variables; Using MDX in aggregate storage applications; Chapter 6:Creating Calculation Scripts; Introduction; Using Essbase Set function commands and Calc All to calculate cubes; Using control flow commands, conditional, and logical operators; Using substitution variables in calculations script; Using UDAs and Calc Two Pass in calculation scripts; Using Attributes in calculation scripts 327 $aClearing data and using the cross- dimensional operators in a calculation script 330 $aThis cookbook is full of immediately useable recipes showing you the advanced development techniques when building Essbase Applications and how to take these applications further. This cookbook offers practical, task-based, and immediately usable recipes covering a wide range of advanced development techniques to build Essbase Applications and take them further. In addition to its cookbook style, which ensures the solutions are presented in a clear step-by-step manner, its explanations go into great detail, which makes it good learning material for everyone who has experience in Essbase and wa 606 $aDatabase management 615 0$aDatabase management. 676 $a005.75 676 $a005.75/85 676 $a005.7585 700 $aRuiz$b Jose R$01724172 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910823869203321 996 $aOracle Essbase 11 development cookbook$94126021 997 $aUNINA