Cargando…
Oracle Essbase 11 Development Cookbook.
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...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Birmingham :
Packt Pub.,
2012.
|
| Temas: | |
| Acceso en línea: | Texto completo |
Tabla de Contenidos:
- Oracle Essbase 11 Development Cookbook; Oracle Essbase 11 Development Cookbook; Credits; About the Author; About the Reviewer; www.PacktPub.com; ; Support files, eBooks, discount offers, and more; Why Subscribe?; Free Access for Packt account holders; Instant Updates on New Packt Books; Preface; What this book covers; What you need for this book; Who this book is for; Conventions; Reader feedback; Customer support; Downloading the example code; Errata; Piracy; Questions; 1. Understanding and Modifying Data Sources; Introduction.
- Setting up an Account or Measures dimension with a parent-child referenceGetting ready; How to do it ... ; How it works ... ; There's more ... ; See also; Setting up dimensions with a generation reference; Getting ready; How to do it ... ; How it works ... ; See also; Adding columns for outline formulas; Getting ready; How to do it ... ; How it works ... ; Adding the solve order column to tables that have ASO formulas; Getting ready; How to do it ... ; How it works ... ; Adding and populating the Sort Order Column; Getting ready; How to do it ... ; How it works ... ; See also; Adding tables for varying attributes.
- Getting readyHow to do it ... ; How it works ... ; See also; Determining hierarchies in relational tables; Getting ready; How to do it ... ; How it works ... ; There's more ... ; See also; Using the Essbase Outline Extractor to extract dimensions; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Using Star Analytics to build your star schema from existing Essbase cubes; Getting ready; How to do it ... ; How it works ... ; See also; 2. Using Essbase Studio; Introduction; ; Advantages of Essbase Studio; Disadvantage of Essbase Studio.
- Creating TBC sample database and connecting to the data sourceGetting ready; How to do it ... ; How it works ... ; Adding user-defined tables; Getting ready; How to do it ... ; How it works ... ; Building your minischema; Getting ready; How to do it ... ; How it works ... ; See also; Setting up joins in a minischema; Getting ready; How to do it ... ; How it works ... ; There's more ... ; See also; Adding tables to a minischema; Getting ready; How to do it ... ; How it works ... ; See also; Using a text file data source; Getting ready; How to do it ... ; How it works ... ; Working with Common Platform Language (CPL); Getting ready.
- How to do it ... How it works ... ; Using Sort Order on data elements; Getting ready; How to do it ... ; How it works ... ; 3. Building the BSO Cube; Introduction; Creating hierarchies using a parent-child reference table; Getting ready; How to do it ... ; How it works ... ; See also; Creating hierarchies using a generation reference table; Getting ready; How to do it ... ; How it works ... ; Adding attribute dimensions to hierarchies; Getting ready; How to do it ... ; How it works ... ; See also ... ; Building a Calendar dimension; Getting ready; How to do it ... ; How it works ... ; Creating date elements; Getting ready; How to do it ...