Skip to content

Latest commit

 

History

History
44 lines (30 loc) · 3.9 KB

modify-or-delete-an-analysis-services-database.md

File metadata and controls

44 lines (30 loc) · 3.9 KB
Raw
title description ms.date ms.service ms.custom ms.topic ms.author ms.reviewer author
Modify or Delete an Analysis Services Database | Microsoft Docs
Modify or delete an Analysis Services database before deployment in SQL Server Data Tools and after deployment in SQL Server Management Studio.
05/02/2018
analysis-services
multidimensional-models
conceptual
kfollis
kfollis
kfollis

Modify or Delete an Analysis Services Database

[!INCLUDEappliesto-sqlas] You can change the name and description of an [!INCLUDEssASnoversion] database before deployment in [!INCLUDEssBIDevStudioFull] and after deployment in [!INCLUDEssManStudioFull]. You can also adjust additional settings on an [!INCLUDEssASnoversion] database, depending on the environment.

Note

You cannot change database properties using [!INCLUDEssBIDevStudioFull] in online mode.

Modifying Databases Using SQL Server Management Studio

Once an [!INCLUDEssASnoversion] database is deployed, you can use [!INCLUDEssManStudioFull] to change the impersonation mode used by [!INCLUDEssASnoversion] when connecting to data sources contained by the database. The impersonation mode allows you to specify the security context used by [!INCLUDEssASnoversion] when attempting to connect to a data source for processing, browsing, or drillthrough purposes.

Modifying Databases Using SQL Server Data Tools

You can use [!INCLUDEssBIDevStudioFull] in project mode to modify the translations for the caption and description of an [!INCLUDEssASnoversion] project used to define a database. For more information about using translations in an [!INCLUDEssASnoversion] 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 [!INCLUDEssASnoversion] database deletes the database and all cubes, dimensions, and mining models in the database. You can only delete an existing [!INCLUDEssASnoversion] database in [!INCLUDEssManStudioFull].

To delete an Analysis Services database

  1. Connect to an [!INCLUDEssASnoversion] instance.

  2. In Object Explorer, expand the node for the connected [!INCLUDEssASnoversion] 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