Report Portal

Comparing DirectQuery and ROLAP for real-time access

In the multidimensional model in SSAS, there is a storage mode called relational OLAP (ROLAP), which is the multidimensional solution for allowing real-time access to relational data sources. In the tabular model in SSAS, the solution for real-time access is a query mode called DirectQuery, which uses a fundamentally different architecture and provides a different set of capabilities. This blog post will explain the differences between the two.


Tags: design, management, performance, rolap, tabular, directquery


2007-2015 VidasSoft Systems Inc.