Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

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.

ms175596.note(en-US,SQL.90).gifNote:
You cannot change database properties using Business Intelligence Development Studio 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. For more information about specifying an impersonation mode, see Securing Analysis Services.

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

For more information about modifying and deleting Analysis Services databases, see one of the topics in the following list:

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.