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)

See Also

Reference