Modifying or Deleting an Analysis Services Database
New: 14 April 2006
You can change the name and description of a Microsoft SQL Server 2005 Analysis Services (SSAS) database before deployment in Business Intelligence Development Studio and after deployment in SQL Server Management Studio. You can also adjust additional settings on an Analysis Services database, depending on the environment.
Note
You cannot change database properties using Business Intelligence Development Studio in online mode.
Modifying Databases Using SQL Server Management Studio
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. For more information about specifying an impersonation mode, see Securing Analysis Services.
Modifying Databases Using Business Intelligence Development Studio
You can use Business Intelligence Development Studio 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 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 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.
How To
For more information about modifying and deleting Analysis Services databases, see one of the topics in the following list:
See Also
Concepts
Creating an Analysis Services Database (SSAS)
Documenting and Scripting an Analysis Services Database