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:
- If you are connected to the Analysis Services database in online mode, you can change the name of the Analysis Services database. If you are working in project mode, you can change the database name for the next deployment of the project. For more information, see How to: Change the Name of an Analysis Services Database in Business Intelligence Development Studio, Configuring Analysis Services Project Properties, and How to: Configure Analysis Services Project Properties.
- You can provide a description of the database that can be presented to users. You can also view the name of the database, but cannot change it. To change the database name, you must edit the properties of the project.
- You can provide translations for the database name and description for one or more languages. For more information, see How to: Add a Database Level Metadata Translation, Cube Translations, Dimension Translations, and Working with Translations (SSAS).
- You can view and modify default account type mappings. Account type mappings are used when one or more measures use the ByAccount aggregation function. For each account type, you can specify an alias and modify the default aggregation function associated with the account type. For more information, see How to: Customize Account Type Mappings for an Analysis Services Database, Defining Semiadditive Behavior, and How to: Add or Delete a Measure.
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)