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. .gif "Note") Note
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. Note
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. Note
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. |
See Also