Jaa


StorageMode Element (ASSL)

Determines the storage mode for the parent element.

Syntax

<Cube> <!-- or Dimension, MeasureGroup, Partition -->
   ...
   <StorageMode>...</StorageMode>
   ...
</Cube>

Element Characteristics

Characteristic Description

Data type and length

String (enumeration)

Default value

MOLAP

Cardinality

0-1: Optional element that can occur once and only once.

Element Relationships

Relationship Element

Parent elements

Cube Element (ASSL), Dimension Element (ASSL), MeasureGroup Element (ASSL), Partition Element (ASSL)

Child elements

None

Remarks

The value of this element is limited to one of the strings listed in the following table.

Value

Description

MOLAP

The parent uses multidimensional OLAP (MOLAP) storage.

ROLAP

The parent uses relational OLAP (ROLAP) storage.

HOLAP

The parent uses hybrid OLAP (HOLAP) storage.

ms126740.note(en-US,SQL.90).gifNote:

This value is not valid for Dimension parent elements.

The enumeration that corresponds to the allowed values for StorageMode in the Analysis Management Objects (AMO) object model is StorageMode.

The elements that correspond to the parents of StorageMode in the Analysis Management Objects (AMO) object model are Cube, Dimension, MeasureGroup, and Partition.

See Also

Reference

Properties (ASSL)

Help and Information

Getting SQL Server 2005 Assistance