Server Architecture and Command Execution - Microsoft SQL Server 2008 Analysis Services - page 484

TABLE 26.1 The Elements of the Process Command

Name Description

Reference to the object to be processed. Object

Specifies the type of processing to perform. Table 26.2 lists
the types of processing supported by Analysis Services.

Type

Defines mapping of the multidimensional object to the rela-
tional data source applied during processing command execu-
tion. (For more information about Bindings , see Chapter 17,
“Loading Data from a Relational Database.”) The Bindings
element is optional in the Process command.
When Bindings are not defined, Analysis Services uses the
Source property of the object being processed. Bindings
defined as part of the Process command are called out-of-line
Bindings (OOL) and overwrite bindings defined in the Source
property of the object.

Bindings

Data source that contains the data to be loaded into the
object. (For more information about Datasource , see Chapter
17.) The Datasource element is optional in the Process
command. When Datasource is not defined, Analysis
Services uses the Datasource object of the current data-
base. The DataSource defined as part of the Process
command is called OOL DataSource and overwrites data
source definition of the database.

Datasource

The data source view that contains the schema used during
command execution. (For more information about data source
views, see Chapter 17.) The DatasourceView element is
optional in the Process command. When DatasourceView is
not defined, Analysis Services uses the DatasourceView
object of the current database. DatasourceView defined as
part of the Process command is called OOL DSV and over-
writes the DSV definition of the database.

DatasourceView

Error configuration objects that specify rules by which Analysis
Services handles errors related to referential integrity of the
data during command execution. (See Chapter 21,
“Dimension and Partition Processing,” for more information
about referential integrity errors.) The ErrorConfiguration
element is optional in the Process command. When it is not
defined, Analysis Services uses the ErrorConfiguration
property of the object being processed.

ErrorConfiguration

Indicates whether the writeback table should be used or
created (if it doesn't exist).

WriteBackTableCreation

LISTING 26.5

The Syntax of the Process Command

<Process>
<Type>processing_type</Type>