Configuring Cube Properties
Cubes have a number of properties that you can set to affect cube-wide behavior. These properties are summarized in the following table.
Note
Some properties are set automatically when the cube is created and cannot be changed.
For more information about how to set cube properties, see Cube Designer (SSAS).
| Property | Description |
|---|---|
AggregationPrefix |
Specifies the common prefix that is used for aggregation names. |
Collation |
Specifies the locale identifier (LCID) and the comparison flag, separated by an underscore: for example, Latin1_General_C1_AS. |
DefaultMeasure |
Contains a Multidimensional Expressions (MDX) expression that defines the default measure for the cube. |
Description |
Provides a description of the cube, which may be exposed in client applications. |
ErrorConfiguration |
Contains configurable error handling settings for handling of duplicate keys, unknown keys, error limits, action upon error detection, error log file, and null key handling. |
EstimatedRows |
Specifies the number of estimated rows in the cube. |
ID |
Contains the unique identifier (ID) of the cube. |
Language |
Specifies the default language identifier of the cube. |
Name |
Specifies the user-friendly name of the cube. |
ProactiveCaching |
Defines proactive cache settings for the cube. |
ProcessingMode |
Indicates whether indexing and aggregating should occur during or after processing. Options are regular or lazy. |
ProcessingPriority |
Determines the processing priority of the cube during background operations, such as lazy aggregations and indexing. The default value is 0. |
ScriptCacheProcessingMode |
Indicates whether the script cache should be built during or after processing. Options are regular and lazy. |
ScriptErrorHandlingMode |
Determines error handling. Options are IgnoreNone or IgnoreAll |
Source |
Displays the data source view used for the cube. |
StorageLocation |
Specifies the file system storage location for the cube. If none is specified, the location is inherited from the database that contains the cube object. |
StorageMode |
Specifies the storage mode for the cube. Values are MOLAP, ROLAP, or HOLAP. |
Visible |
Determines the visibility of the cube. |
Note
For more information about setting values for the ErrorConfiguration property when working with null values and other data integrity issues, see Handling Data Integrity Issues in Analysis Services 2005.