Introduction

MicroStrategy's in-memory technology is the most important part of the Intelligence Server extension named OLAP Services.

The OLAP Services' main advantage is the ability to perform very fast queries using desktop, web, and mobile clients without the need to overload the RDBMS server. It also allows for slicing and dicing data directly in the Intelligent Server memory without having to re-execute the SQL statement against the data warehouse.

Formerly known as Intelligent Cubes and now rebranded In-Memory cubes, this technology improves the efficiency and performance of reports, documents, and Visual Insight analyses. In previous chapters we already took advantage of some OLAP features like page-by, pivoting, dynamic aggregation, and view filters; we are now exploring the use of multidimensional datasets to leverage the fast response times and the MOLAP capabilities of In-Memory cubes.

Some other advantages of cubes:

• Can be shared and used by many reports/documents

• Can be refreshed...