Dimension Storage
Dimensions in Microsoft SQL Server 2005 Analysis Services (SSAS) 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
MOLAP
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.
ROLAP
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.
Important
If a dimension uses the ROLAP storage mode and the dimension is included in a cube that uses MOLAP storage, any schema changes to its source table must be followed by immediate processing of the cube. Failure to do this may result in inconsistent results when querying the cube. Related topic:Processing Objects Using Integration Services.
See Also
Concepts
Partition Storage Modes and Processing