Applies To: SQL Server 2016 Preview
Dimensions in Microsoft SQL Server Analysis Services support two storage modes:
Relational OLAP (ROLAP)
Multidimensional OLAP (MOLAP)
The storage mode determines the location and form of a dimension's data. MOLAP is the default storage mode for dimensions. Related topics:Partition Storage Modes and Processing
Data for a dimension that uses MOLAP is stored in a multidimensional structure in the instance of Analysis Services. This multidimensional structure is created and populated when the dimension is processed. MOLAP dimensions provide better query performance than ROLAP dimensions.
Data for a dimension that uses ROLAP is actually stored in the tables used to define the dimension. The ROLAP storage mode can be used to support large dimensions without duplicating large amounts of data, but at the expense of query performance. Because the dimension relies directly on the tables in the data source view used to define the dimension, the ROLAP storage mode also supports real-time OLAP.