05357nam 2200649 a 450 991045751960332120200520144314.01-283-45346-097866134534641-84968-327-1(CKB)2550000000087698(EBL)943412(OCoLC)796384666(SSID)ssj0000647041(PQKBManifestationID)11383131(PQKBTitleCode)TC0000647041(PQKBWorkID)10593288(PQKB)10068348(MiAaPQ)EBC943412(PPN)228040655(Au-PeEL)EBL943412(CaPaEBR)ebr10529555(CaONFJC)MIL345346(EXLCZ)99255000000008769820120303d2012 uy 0engur|n|---|||||txtccrOracle Essbase 11 development cookbook[electronic resource] over 90 advanced development recipes to build and take your Oracle Essbase applications further /Jose R. RuizBirmingham, U.K. Packt Enterprise20121 online resource (400 p.)"Quick answers to common problems"--Cover.Includes index.1-84968-326-3 Cover; 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 dimensionsUsing 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 tableAdding 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 reportUsing 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 formulasUsing 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 scriptsClearing data and using the cross- dimensional operators in a calculation scriptThis 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 waDatabase managementElectronic books.Database management.005.75005.75/85005.7585Ruiz Jose R964117MiAaPQMiAaPQMiAaPQBOOK9910457519603321Oracle Essbase 11 development cookbook2186449UNINA