Book Image

Oracle Essbase 11 Development Cookbook

By : Jose R Ruiz
Book Image

Oracle Essbase 11 Development Cookbook

By: Jose R Ruiz

Overview of this book

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.
Table of Contents (17 chapters)
Oracle Essbase 11 Development Cookbook
About the Author
About the Reviewer

Building a Calendar dimension

In this recipe, we will create a Fiscal calendar using the CALENDAR dimension functionality in Essbase Studio. The Calendar dimension was a long awaited function in Essbase. Prior to the Calendar dimension, you had to create your own template in an Essbase cube. When you were designing another cube, you would simply copy that dimension from one outline to the next. This worked fine if you only had to worry about a simple Gregorian calendar, but it was slightly more challenging for retail, broadcast calendars, or fiscal calendars. In this recipe, we will be building the 4-5-4 fiscal calendar for a retail company. The retail calendar comes from the National Federation Retailer and is designed to track year over year data across multiple years. The 4-5-4 is the pattern that is used in the quarters. Using this pattern, the first month of the quarter will have four weeks, the second month five weeks, and the last month has four weeks. This calendar also takes into...