Export (0) Print
Expand All

Modify or Delete an Analysis Services Database

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

Note Note

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

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

You can use SQL Server Data Tools (SSDT) in project mode to modify the translations for the caption and description of an Analysis Services project used to define a database. For more information about using translations in an Analysis Services database, see International Considerations (Analysis Services - Multidimensional Data).

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 an existing Analysis Services database deletes the database and all cubes, dimensions, and mining models in the database. You can only delete an existing Analysis Services database in SQL Server Management Studio.

To delete an Analysis Services database

  1. Connect to an Analysis Services instance.

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

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft