Skip to content

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

Latest commit

 

History

History
51 lines (38 loc) · 3.97 KB

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

File metadata and controls

51 lines (38 loc) · 3.97 KB
title Modify or Delete an Analysis Services Database | Microsoft Docs
ms.custom
ms.date 03/06/2017
ms.prod sql-server-2014
ms.reviewer
ms.technology analysis-services
ms.topic conceptual
helpviewer_keywords
databases [Analysis Services], modifying
removing databases
deleting databases
dropping databases
databases [Analysis Services], deleting
modifying databases
ms.assetid e48e3988-c091-4379-aabc-4da62f709a7e
author minewiskan
ms.author owend
manager craigg

Modify or Delete an Analysis Services Database

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

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