Modify or Delete an Analysis Services Database

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

You can change the name and description of an SQL Server Analysis Services database before deployment in SQL Server Data Tools and after deployment in SQL Server Management Studio. You can also adjust additional settings on an SQL Server Analysis Services database, depending on the environment.

Note

You cannot change database properties using SQL Server Data Tools in online mode.

Modifying Databases Using SQL Server Management Studio

Once an SQL Server Analysis Services database is deployed, you can use SQL Server Management Studio to change the impersonation mode used by SQL Server Analysis Services when connecting to data sources contained by the database. The impersonation mode allows you to specify the security context used by SQL Server Analysis Services when attempting to connect to a data source for processing, browsing, or drillthrough purposes.

Modifying Databases Using SQL Server Data Tools

You can use SQL Server Data Tools in project mode to modify the translations for the caption and description of an SQL Server Analysis Services project used to define a database. For more information about using translations in an SQL Server Analysis Services database, see Globalization scenarios for Analysis Services.

You can also set the aliases and aggregation functions associated with account types used by account attributes in dimensions contained by the database. Aliases allow you to select the business-specific terminology used by your organization for the account types in a chart of accounts. The account types are used by members of an account attribute to indicate how to aggregate measures over each member by using the aggregation functions specified for each account type contained in the database. For more information about account attributes, see Attributes and Attribute Hierarchies.

Deleting Databases

Deleting an existing SQL Server Analysis Services database deletes the database and all cubes, dimensions, and mining models in the database. You can only delete an existing SQL Server Analysis Services database in SQL Server Management Studio.

To delete an Analysis Services database

  1. Connect to an SQL Server Analysis Services instance.

  2. In Object Explorer, expand the node for the connected SQL Server Analysis Services instance and ensure that the object to be deleted is visible.

  3. Right-click the object to be deleted and select Delete.

  4. In the Delete Object dialog box, click OK.

See Also

Document and Script an Analysis Services Database