Any Body Please keep questions related to Hyperion Essbase, Planning, reports.

What is Multidimensional database? How is it different from Relational database and how it works?

Multidimensional databases consolidate and calculate data to provide different views. With Multidimensional databases users can pivot the data to see the information from different view point. It contains Outlines that defines all the elements of the database.In Hyperion Essbase two types of Dimensions.Standard Dimensions: It represents the core components of the business plan and often related to departmental functions.These are 2 types: 1. Dense dimensions :- It represents the member which are having the occurance of data is high.2. Sparsed Dimensions.Attribute Dimensions: These are special type dimensions associated with standard dimensions. We can say these are the characteristics of the members.Relational databases are operational type (most often, transactional type).