Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

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:

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.