Share via


Configuring Database Properties in Business Intelligence Development Studio

New: 14 April 2006

There are a number of Microsoft SQL Server 2005 Analysis Services (SSAS) 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, Working with Remote Partitions, and How to: Define a Remote Partition.

See Also

Tasks

How to: Add a Database Level Metadata Translation
How to: Customize Account Type Mappings for an Analysis Services Database

Concepts

Configuring Analysis Services Project Properties

Other Resources

Database Properties Dialog Box (SSAS)

Help and Information

Getting SQL Server 2005 Assistance