Databases Reference
In-Depth Information
Loading data into an Essbase database is the process of loading specific data values
into your Essbase database, based on a predefined database outline. This predefined
database outline contains all of the necessary data attributes to organize the data into
a logical and recognizable format.
Building dimensions in an Essbase database outline is the process of loading data
as data attributes, instead of data values, into the database in the form of adding
new dimension members to the database outline. The missing data attributes in
the database outline that are contained in the data are added by the dimension
build process so that the accompanying data values can be loaded and not rejected.
Summary
Wow, who knew Essbase was such an easy to use and versatile tool when it came
to loading data and maintaining your outline?
Let's see, we have covered the how and why of making your data Essbase-friendly.
We have also learned what it means to make data Essbase-friendly and what you
need to do to make it so.
As if that wasn't enough, you've also learned all about what are referred to as data
sources for Essbase. You now know that a data source can be merely data values
you load into your Essbase database, based on a predefined database outline and
data attributes accompanying the data values.
You have learned about the various types of data sources, how Essbase deals with
them, and what you need to do to filter, manipulate, or cleanse them before use.
After all of that, we took all what you've learned about data and data sources and
applied it by creating your first data load rules in Oracle Essbase. You then used
that load rule to load some honest to goodness real data into your Esscar database.
That was easy, wasn't it?
In the next chapter, we get into the handy dandy Essbase calculation script. This
small tool is pretty much singularly responsible for the vast differences between
Oracle Essbase and any typical relational database. Not only can you calculate
data on the fly, you create new data elements that are derived from component
data elements that exist in the database, without loading large amounts of data if
the results you want can be derived from the data already existing in your database.
Turn the page and let's get started on calcs!
