MOLAP (Multi dimensional ONLINE Analytical Processing) : MOLAP is the most used storage type. Its designed to offer maximum query performance to the users. the data and AGGREGATIONS are stored in a MULTIDIMENSIONAL format, compressed and optimized for performance. This is both good and bad. When a cube with MOLAP storage is processed, the data is pulled from the relational database, the aggregations are performed, and the data is stored in the AS database. The data inside the cube will refresh only when the cube is processed, so latency is high.

Advantages:

1. Since the data is stored on the OLAP server in optimized format, queries (even complex calculations) are faster than ROLAP.
2. The data is compressed so it takes up LESS space.
3. And because the data is stored on the OLAP server, you don’t need to keep the connection to the relational database.
4. Cube browsing is fastest USING MOLAP.

MOLAP (Multi dimensional Online Analytical Processing) : MOLAP is the most used storage type. Its designed to offer maximum query performance to the users. the data and aggregations are stored in a multidimensional format, compressed and optimized for performance. This is both good and bad. When a cube with MOLAP storage is processed, the data is pulled from the relational database, the aggregations are performed, and the data is stored in the AS database. The data inside the cube will refresh only when the cube is processed, so latency is high.

Advantages: