OlapStorageModes
Note
This feature will be removed in the next version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible.
Enumerates values for the OlapMode property.
Constant | Description | Applies to |
---|---|---|
olapmodeAggsMolapIndex |
Reserved for future use. |
n/a |
olapmodeAggsRolap |
Reserved for future use. |
n/a |
olapmodeHybridIndex |
Fact table data is stored in relational OLAP (ROLAP), and aggregations are stored in multidimensional OLAP (MOLAP). |
Databases, cubes, and partitions (excluding virtual cubes and linked cubes) |
olapmodeMolapIndex |
Fact table data is stored in MOLAP, and aggregations are stored in MOLAP. |
Databases, cubes, and partitions (excluding virtual cubes) |
olapmodeRolap |
All data is stored in ROLAP. |
Databases, cubes, and partitions (excluding virtual cubes and linked cubes) |