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 |
|