Cube or Model Properties Dialog Box (SSAS)

Use the Database Properties dialog box in SQL Server Management Studio to set the properties of a cube or model database. You can display the dialog box by right-clicking a cube or model in Object Explorer and selecting Properties.

Options

Term

Definition

Name

Displays the name of the cube or model.

ID

Displays the identifier of the cube or model.

Description

Displays the description of the cube or model.

Create Timestamp

Displays the date and time the cube or model was created.

Last Schema Update

Displays the date and time the metadata for the cube or model was last updated.

Script Cache Processing Mode

Select the processing mode to use for the script cache of the cube or model. For more information about the values for this property, see ScriptCacheProcessingMode.

Processing Mode

Select the processing mode to use for the cube or model. For more information about the values for this property, see ProcessingMode.

Storage Location

Type the folder to use as the default storage location for measure groups and partitions associated with the cube or model, or click the ellipsis button (...) to display the Browse for Remote Folder dialog box to select a folder. For more information about the Browse for Remote Folder dialog box, see Browse for Remote Folder Dialog Box (Analysis Services - Multidimensional Data).

For more information about the values for this property, see StorageLocation.

State

Displays the processing state of the cube or model. For more information about the values for this property, see State.

LastProcessed

Displays the date and time the cube or model was last processed.

See Also

Reference

Analysis Services Designers and Dialog Boxes (Multidimensional Data)

Concepts

Cube Objects (Analysis Services - Multidimensional Data)