Edit

Set Multidimensional Database Properties (Analysis Services)

  • Article

Applies to: SQL Server Analysis Services Azure Analysis Services Fabric/Power BI Premium

There are a number of Microsoft SQL Server SQL Server Analysis Services database properties that you can configure in the SQL Server Data Tools database designer.

In this designer, you can perform the following types of tasks:

  • If you are connected to the SQL Server Analysis Services database in online mode, you can change the name of the SQL Server 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 Translation support in Analysis Services.

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

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 Element (ASSL).
Collation When the SQL Server Analysis Services project is deployed to an SQL Server 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 SQL Server 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 SQL Server Analysis Services project is deployed to an SQL Server 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

Database Properties Dialog Box (SSAS - Multidimensional)
Configure Analysis Services Project Properties (SSDT)