Databases Reference
In-Depth Information
Building the Essbase Outline
We know that any true technology geek gets impatient, at the very least, when
made to suffer through too much reading and page turning. We too feel the same
way, but it was absolutely necessary to give you everything we did in the previous
two chapters. Likewise, it is also necessary to give you every detail in this chapter.
You are aware of the fact that the Esscar Motor Company is hunting for a new
system to provide their production and sales planning department with the ability
to quickly create sales and production forecasts, profit forecasts, scenario over
scenario what-if analysis, and more.
Armed with what you have learned in the previous chapters and using the Oracle
Essbase Esscar application and database you created in Chapter 2, we will now
guide you through building an honest-to-goodness real and usable database outline.
We will show you how to build the dimensions necessary to describe the data using
a step-by-step approach. We will add members to the dimensions that organize and
store the data. We will also show you how to determine the best storage methods for
the data. Finally, we will show you the different ways to load the data.
If you haven't done so yet, we recommend getting yourself near to a PC that has
Essbase Administration Services (EAS) properly installed and connected to an active
Essbase server. You'll want to perform the tasks we will be taking you through.
Before we begin
Before we get too deeply involved with the Essbase outline, we just wanted to be
clear that the information and examples presented in this chapter assume that you
have created your database using the BSO.
We devote most of the future chapter to explaining the BSO and the ASO options,
both their similarities and their differences.
So remember, the BSO is the flavor of this chapter.
