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

Set Multidimensional Database Properties (Analysis Services)

There are a number of Microsoft SQL Server Analysis Services database properties that you can configure in the SQL Server Data Tools (SSDT) 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 Rename a Multidimensional Database (Analysis Services) and Configure Analysis Services Project Properties (SSDT).

  • 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 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 modifying the default aggregation, see Define Semiadditive Behavior.

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 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.

Estimated Size

Provides an estimated size of the database files on disk. If data is stored in multiple locations, this estimate will be limited to just the data files stored under the database folder.

EstimatedSize can also be used as a basis for estimating memory. Typically, memory requirements are larger than the size of data on disk due to additional data structures that are created when the database is loaded into memory.

To further estimate memory requirements, you can also use Task Manager to look at the Analysis Services process memory before and after processing the database and observe the memory utilized as a method for understanding the memory requirements of the database.

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.

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

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.