Databases Reference
In-Depth Information
Calculating your Essbase
Cube
Let's take a minute and review what we have completed so far. We now have a fully
functioning Essbase operation set up. The server software is installed, the client
software is installed, a real application and a database are built, and the database is
loaded with data. It's all there and ready for the heart of the system. If the database
outline is the foundation of an Essbase database then the calculation scripts are the
heart of an Essbase database.
Although you can calculate both an ASO database and a BSO database, unless
otherwise noted, the instructions in this chapter pertain primarily to the BSO.
In this chapter, you will learn about one of the most important pieces of functionality
in Oracle Essbase. It is one of the main reasons why Oracle Essbase, with its cube
technology is so vastly superior to any relational database when it comes to data
analytics, analysis, and reporting. This important functionality is the Essbase
database calculation.
To help you put the power of the Essbase database calculation to work for you,
we will take you through the steps needed to be able to create and run an Essbase
database calculation script. We will also show you the various types of database
calculation scripts. Essbase database calculation scripts can be in the form
of an Essbase database calculation script file, a database member formula written
in the database outline and executed by a database calculation script, or a database
outline member formula executed by Essbase only when the data is needed
(dynamically calculated member).
