Oracle Essbase 11 Development Cookbook

Description

Oracle Essbase is a Multi-Dimensional Online Analytical Processing (OLAP) server, providing a rich environment for effectively developing custom analytic and enterprise performance management applications. Oracle Essbase enables business users to quickly model complex business scenarios.

This practical cookbook shows you the advanced development techniques when building Essbase Applications and how to take these applications further.

Packed with over 90 task-based and immediately reusable recipes, this book starts by showing you how to use a relational data model to build and load an Essbase cube and how to create a data source, prepare the mini schema, and work with the data elements in Essbase Studio. The book then dives into topics such as building the BSO cube, building the ASO cube, using EAS for development, creating Calculation Scripts and using MaxL to automate processes.

CONTENTS:

Preface

Chapter 1: Understanding and Modifying Data Sources

Chapter 2: Using Essbase Studio

Chapter 3: Building the BSO Cube

Chapter 4: Building the ASO Cube

Chapter 5: Using EAS for Development

Chapter 6: Creating Calculation Scripts

Chapter 7: Using MaxL to Automate Process

Chapter 8: Data Integration

Chapter 9: Provisioning Security Using MaxL Editor or Shared Services

Chapter 10: Developing Dynamic Reports

Index