Reasons to Split Databases

Essbase Overview


There are many reasons for splitting a database.

Time zones

For example, suppose that a company maintains an organizational database that contains several international subsidiaries in several time zones. Each subsidiary relies on time-sensitive financial calculations. You can split the database for groups of subsidiaries in the same time zone to ensure that financial calculations are timely.

Separate information by subsidiary

You can also use a partitioned application to separate information by subsidiary.

Suppression of interdimensional irrelevance

Essbase - Suppression of interdimensional irrelevance by splitting the database

Discover More
Essbase Short Cycle
Essbase - The OLAP Design Cycle (to create an optimized database)

A contains two types of values : the values that you enter or load (input data) and the values that are calculated from the input data (calculated data) Then a typical conforms to the following...

Share this page:
Follow us:
Task Runner