Database Properties Dialog Box (SSAS - Multidimensional)


Use the Database Properties dialog box in SQL Server Management Studio to set the properties of a database in an Analysis Services database. You can display the Database Properties dialog box by right-clicking a database in Object Explorer and selecting Properties.

NameType to change the name of the database.
IDDisplays the identifier of the database.
DescriptionType to change the description of the database.
Create TimestampDisplays the date and time the database was created.
Last Schema UpdateDisplays the date and time the metadata for the database was last updated.
Last UpdateDisplays the date and time the data for the database was last updated.
Data Source Impersonation InfoSelect the impersonation information used by the database when connecting to and interacting with data sources contained by the database. Valid values include the following:

 ImpersonateAccount (use a specific Windows user name and password).

 ImpersonateService (use the service account).

 ImpersonateCurrentUser (use the credentials of the current user).

 Default (use the service account for MOLAP operations and current user for data mining).

Although you can set data source impersonation settings at the database level, doing so will only affect those data sources that specify Inherit for their impersonation settings. Impersonation settings specified directly on the data source will always override any settings that are specified at the database level.

When choosing an impersonation option, consider the types of operations that will need to be supported. Some operations, such as processing, cannot be performed by
Last ProcessedDisplays the date and time the database was last processed.
Estimated SizeDisplays the estimated size of the database.
Storage LocationSpecifies the location of the database. If the database is located in the default Data directory, this value will be empty.

Analysis Services Designers and Dialog Boxes (Multidimensional Data)
Multidimensional Model Databases (SSAS)