The Physical Data Model - Microsoft SQL Server 2008 Analysis Services - page 361

TABLE 20.1

Partition Properties

Property Description

Represents the date and time when Analysis Services created
the partition.

CreatedTimestamp

Defines the error-handling rules used during processing of the
partition. For more information about error configurations, see
Chapter 21, “Dimension and Partition Processing.”

ErrorConfiguration

Defines the amount of data, in bytes, which you expect to be
loaded into the partition. This property helps Analysis Services
determine the best strategy to use during partition processing.

EstimatedSize

Defines the number of records that you expect to be loaded into
a partition. Similar to the EstimatedSize property, this property
helps Analysis Services determine the best strategy to use
during partition processing.

EstimatedRows

Represents the date and time at which the partition was last
updated.

LastSchemaUpdate

Represents the date and time at which Analysis Services last
successfully processed the partition.

LastProcessed

Defines the automatic reprocessing rules for the partition when
data changes in the underlying data source. For more informa-
tion about proactive caching, see Chapter 24, “Proactive
Caching and Real-Time Updates.”

ProactiveCaching

Defines the method used to load the partition with data. You can
load data and build indexes at the same time, or you can
choose to load data, but not build indexes, during partition
processing. Indexes can be built lazily when Analysis Services
finds an appropriate time. We recommend that you avoid lazy
processing: Using it makes it difficult to predict when indexes
will be constructed and when Analysis Services will efficiently
use the partition.

ProcessingMode

Defines the priority of building indexes for this partition, relative
to other partitions, during lazy processing.

ProcessingPriority

Defines the identifier for the Datasource object used by the
remote partition. Remote partitions enable you to place parti-
tions on a different server, providing unlimited extension of the
volume of stored data. (We discuss remote partitions later in
this chapter.)

RemoteDatasourceID