Please enable JavaScript.
Coggle requires JavaScript to display documents.
Multidimensional and Relational - Coggle Diagram
Multidimensional and Relational
Multidimensional and relational
Online analytical processing (OLAP)
Key to OLAP systems are
multidimensional database
not only consolidate and calculate data
but also provide retrieval and calculation of a variety of data subsets
depends upon data base outline
database outline, the structure that defines
all elements of the database
Users can Pivot the data , limited to outline specified in multidim database.
Dimensions
- highest consolidation level in the database outline
Members are the individual components of a dimension
OUTLINE CHARACTERISTICS
Defines the structural relationships between members in an Essbase database
Organizes data in the database
Defines the consolidations and mathematical relationships between items
a multidimensional, multiuser, client-server computing
environment
for users
who need to analyze enterprise data
successful OLAP application provides information as needed; that is, it provides “just-in-time” information for effective decision-making.
Essbase—a multi-threaded OLAP database software
Essbase application components reside on a server.
database outlines
calculation scripts,
application control
multidimensional database information
Dense and Sparse
Essbase maximizes performance by dividing the
standard dimensions
of an application into two types:
dense dimensions and sparse dimensions.
Sparse: Lack data values for the majority of member combinations.
Dense: High probability that one or more cells is occupied in every combination of dimensions.
Attribite Dimensions are always SPARSE Dimensions
Essbase can make recommendations for the sparse-dense configuration of dimensions based on the following factors:
● The time and accounts tags on dimensions
● The probable size of the data blocks
● Characteristics that you attribute to the dimension
The
data block
represents all the dense dimension members for its combination of sparse
dimension members
The index
represents the combinations of sparse standard dimension members. It contains an entry for each unique combination of sparse
standard dimension members for which at least one data value exists