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:
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 using 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 using Business Intelligence Development Studio, Cube Translations, Dimension Translations, and Translations (Analysis Services - Multidimensional Data).
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 using Business Intelligence Development Studio and Defining Semiadditive Behavior.
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. |
See Also