Databases Reference
In-Depth Information
Types of Essbase databases
Essbase offers two types of databases that can be created. The first and most
important choice is the normal
or standard database. This database will be used
in 100 percent of the applications you build in Essbase.
The normal (non-currency) database
The normal non-currency database is the cube you have heard so much about. All
data dimensions and members are defined in the outline of this cube. The normal
Essbase database is widely used for most data analysis where conversion of currency
values is not required. In our Esscar Motor Company example, we could track and
forecast vehicle production, sales volumes, trends, stocks, and all quite nicely with
a simple to use non-currency database.
Essbase currency database
The currency conversion database is a great tool for analyzing data across
international markets, which employ differing currencies. The currency conversion
database stores the currency conversion values for each individual country. When
currency data is requested by the user in his local currency, the normal cube will
dynamically access the currency cube and convert the data on the fly.
The symbiotic currency cube can be conceptually
thought of as the currency dimension of the primary
normal
cube.
Database components
Let's now go through some of the most important components in every database.
• The database outline
• Linked Reporting Objects
• Partitions
• Calculation scripts
• Report scripts
• Rules iles
