Dela via


Database Properties (Analysis Services - Multidimensional Data)

There are a number of Microsoft SQL Server Analysis Services database properties that you can configure in the Business Intelligence Development Studio database designer.

In this designer, you can perform the following types of tasks:

Database Properties

In addition to the above, there are a number of properties of a database that you can configure in the Properties window.

Property

Description

Aggregation Prefix

The common prefix that can be used for aggregation names for all of the partitions in a database. For more information, see AggregationPrefix (MDStore Interface), and AggregationPrefix Element (ASSL).

Collation

When the Analysis Services project is deployed to an Analysis Services instance, the database will inherit from the Collation server property unless a different value is provided here.

DataSourceImpersonationInfo

Specifies the default impersonation mode for all data source objects in the database. This is the mode that the Analysis Services service uses when processing objects, synchronizing servers, and executing the OpenQuery and SystemOpenSchema data mining statements.

Language

When the Analysis Services project is deployed to an Analysis Services instance, the database will inherit from the Language server property unless a different value is provided here.

MasterDataSource ID

Used with remote partitions. For more information, see Remote Partitions.