Limit search to available items
Book Cover
E-book
Author Ruiz, Jose R

Title Oracle Essbase 11 Development Cookbook
Published Birmingham : Packt Pub., 2012

Copies

Description 1 online resource (676 pages)
Contents 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 ..
Summary 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
Notes Print version record
SUBJECT Essbase (Computer file) http://id.loc.gov/authorities/names/n96119638
Essbase (Computer file) fast
Subject Database management.
Database management
Form Electronic book
ISBN 9781849683272
1849683271