Databases Reference
In-Depth Information
When you make changes to your database outline, the changes may also affect the
way the data itself is stored. Changes such as moving a member or changing a
Dense
setting to a
Sparse
setting will always require you to perform an
Outline and Data
restructure. When the restructure is called for, Essbase will actually perform what
could be best compared to in the relational world as database reorganization. All of
the existing data is unloaded and then reloaded into a structure that is most efficient
for the new database outline configuration and settings.
When Essbase is performing an
Outline Only
database restructure, the database
page files are not touched as only the database outline file is reorganized and resaved.
An
Outline Only
restructure is triggered by making simple changes to the database,
including adding or updating an alias table or adding or updating a member property.
When Essbase deems it necessary to restructure the entire database, it will completely
rebuild the database's page and index files. This type of database restructure is
sometimes referred to as a
Dense
restructure. What triggers a
Dense
restructure is
actually moving around the members in the database outline, adding new members
to the outline, or changing the
Dense
and
Sparse
setting on a dimension.
Very Important
When performing a database restructure, Essbase actually rebuilds
new temporary database page files from the existing page files. When
finished, Essbase will delete the old page files and rename the new ones.
Prior to any database restructure always make sure you have extra
storage on your server. If the database you are restructuring is 30GB and
you only have 20GB of space available Essbase will keep on going with
the restructure until the disc space runs out and crashes the server!
M
A
R
K
E
T
S
CALENDAR
PERIODS
