Sdílet prostřednictvím


General (Partition Properties Dialog Box) (SSMS)

Use the General page of the Partition Properties dialog box in SQL Server Management Studio to set the general properties of a partition in a measure group for a cube in an Microsoft SQL Server Analysis Services database.

Options

Term

Definition

Aggregation Design ID

Displays the identifier of the aggregation design used by the partition.

Aggregation Prefix

Displays the default prefix of aggregation instances that are contained by the partition.

Create Timestamp

Displays the date and time the partition was created.

Current Storage Mode

Displays the current storage mode of the partition.

NoteNote
This mode may vary depending on the proactive caching settings for the partition. For more information about proactive caching, see Proactive Caching (Partitions).

Description

Type to change the description of the partition.

Estimated Rows

Type the estimated number of rows in the underlying data source represented by the partition. This value is used during processing to estimate the time and storage required to process the partition.

Estimated Size

Displays the estimated size of the partition.

ID

Displays the identifier of the partition.

Last Processed

Displays the date and time the partition was last processed.

Last Schema Update

Displays the date and time the metadata for the partition was last updated.

Name

Displays the name of the partition.

Processing Mode

Select the processing mode for the partition. For more information about processing modes for Analysis Services objects, see Processing Analysis Services Objects.

Remote Data Source ID

Displays the identifier of the remote data source from which the source data for the partition is retrieved.

NoteNote
This property contains a value only for remote partitions.

Slice

Displays the expression that identifies the data slice represented by the partition.

Source

Displays the table or query that provides the source data for the partition.

State

Displays the current processing state of the partition.

Storage Location

Displays the folder in which the data for the partition is stored.

NoteNote
This property contains a value only if a storage location other than the default storage location for the Analysis Services instance is specified.

Type

Displays the type of the partition.