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 2005 Analysis Services (SSAS) 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.
Note:
This mode may vary depending on the proactive caching settings for the partition. For more information about proactive caching, see Proactive Caching.
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 in Analysis Services.
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
Reference
Partition Properties Dialog Box (SSMS)
Selection (Partition Properties Dialog Box) (SSMS)
Proactive Caching (Partition Properties Dialog Box) (SSMS)
Error Configuration (Partition Properties Dialog Box) (SSAS)
Other Resources
Partitions (Analysis Services)
Remote Partitions