|
|
|
|
|
|
|
|
|
1. |
Record Nr. |
UNINA9910823869203321 |
|
|
Autore |
Ruiz Jose R |
|
|
Titolo |
Oracle Essbase 11 development cookbook : over 90 advanced development recipes to build and take your Oracle Essbase applications further / / Jose R. Ruiz |
|
|
|
|
|
|
|
Pubbl/distr/stampa |
|
|
Birmingham, U.K., : Packt Enterprise, 2012 |
|
|
|
|
|
|
|
ISBN |
|
1-283-45346-0 |
9786613453464 |
1-84968-327-1 |
|
|
|
|
|
|
|
|
Edizione |
[1st ed.] |
|
|
|
|
|
Descrizione fisica |
|
1 online resource (400 p.) |
|
|
|
|
|
|
Disciplina |
|
005.75 |
005.75/85 |
005.7585 |
|
|
|
|
|
|
|
|
Soggetti |
|
|
|
|
|
|
Lingua di pubblicazione |
|
|
|
|
|
|
Formato |
Materiale a stampa |
|
|
|
|
|
Livello bibliografico |
Monografia |
|
|
|
|
|
Note generali |
|
"Quick answers to common problems"--Cover. |
Includes index. |
|
|
|
|
|
|
|
|
Nota di contenuto |
|
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 dimensions |
Using 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 |
Adding 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 |
Using 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 |
Using 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 |
Clearing data and using the cross- dimensional operators in a calculation script |
|
|
|
|
|
|
Sommario/riassunto |
|
This 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 |
|
|
|
|
|
|
|
| |