Info
- Utilizzare la checkbox di selezione a fianco di ciascun documento per attivare le funzionalità di stampa, invio email, download nei formati disponibili del (i) record.
Oracle Essbase 11 development cookbook [[electronic resource] ] : over 90 advanced development recipes to build and take your Oracle Essbase applications further / / Jose R. Ruiz
| Oracle Essbase 11 development cookbook [[electronic resource] ] : over 90 advanced development recipes to build and take your Oracle Essbase applications further / / Jose R. Ruiz |
| Autore | Ruiz Jose R |
| Pubbl/distr/stampa | Birmingham, U.K., : Packt Enterprise, 2012 |
| Descrizione fisica | 1 online resource (400 p.) |
| Disciplina |
005.75
005.75/85 005.7585 |
| Soggetto topico | Database management |
| Soggetto genere / forma | Electronic books. |
| ISBN |
1-283-45346-0
9786613453464 1-84968-327-1 |
| Formato | Materiale a stampa  |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| 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 |
| Record Nr. | UNINA-9910457519603321 |
Ruiz Jose R
|
||
| Birmingham, U.K., : Packt Enterprise, 2012 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Oracle Essbase 11 development cookbook [[electronic resource] ] : over 90 advanced development recipes to build and take your Oracle Essbase applications further / / Jose R. Ruiz
| Oracle Essbase 11 development cookbook [[electronic resource] ] : over 90 advanced development recipes to build and take your Oracle Essbase applications further / / Jose R. Ruiz |
| Autore | Ruiz Jose R |
| Pubbl/distr/stampa | Birmingham, U.K., : Packt Enterprise, 2012 |
| Descrizione fisica | 1 online resource (400 p.) |
| Disciplina |
005.75
005.75/85 005.7585 |
| Soggetto topico | Database management |
| ISBN |
1-283-45346-0
9786613453464 1-84968-327-1 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| 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 |
| Record Nr. | UNINA-9910779069203321 |
|
Ruiz Jose R
|
||
| Birmingham, U.K., : Packt Enterprise, 2012 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Oracle Essbase 11 development cookbook : over 90 advanced development recipes to build and take your Oracle Essbase applications further / / Jose R. Ruiz
| Oracle Essbase 11 development cookbook : over 90 advanced development recipes to build and take your Oracle Essbase applications further / / Jose R. Ruiz |
| Autore | Ruiz Jose R |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | Birmingham, U.K., : Packt Enterprise, 2012 |
| Descrizione fisica | 1 online resource (400 p.) |
| Disciplina |
005.75
005.75/85 005.7585 |
| Soggetto topico | Database management |
| ISBN |
1-283-45346-0
9786613453464 1-84968-327-1 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| 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 |
| Record Nr. | UNINA-9910823869203321 |
|
Ruiz Jose R
|
||
| Birmingham, U.K., : Packt Enterprise, 2012 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||