MicroStrategy provides significant features to support its state-of-the-art in-memory analytics, which includes improved memory usage for data refresh for partitioned intelligent cubes, improved flexible partitioning for multi-table cubes, and improved in-memory cube troubleshooting. In-memory datasets can be created using MicroStrategy OLAP Services and MicroStrategy’s Parallel Relational In-Memory Engine (PRIME). OLAP Services is an extension of MicroStrategy Intelligence Server and uses Intelligent Cube Technology, an in-memory version of report data that can be manipulated by the MicroStrategy Analytical Engine. The OLAP services are a combination of Multidimensional Online Analytical Processing (MOLAP) and Relational Online Analytical Processing (ROLAP), which allow organizations to analyze reports obtained directly from the in-memory intelligent cubes, instead of from the data warehouse and manipulate them in real time. Request
MICROSTRATEGY INCORPORATED Pricing to get more information.
The advantages of using MicrsoStrategy’s in-memory analytics are that it provides a broader schema support along with a broader analytic functionality and search indexing, which significantly reduces the computation time required for analytics. The major disadvantage of using PRIME is that it is not an open database that runs transactions or connects to third-party BI apps. Only MicroStrategy software can connect to PRIME which can be a hindrance to organizations using third-party apps.