O'Reilly logo

Oracle Essbase 11 Development Cookbook by Jose R. Ruiz

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required