How to: Create an Analysis Services Database using SQL Server Management Studio

You can use SQL Server Management Studio to create a new, empty database on an instance of SQL Server Analysis Services.

To create an Analysis Services database

  1. Connect to an Analysis Services instance.

  2. In Object Explorer, expand the node for the connected Analysis Services instance.

  3. Right-click the Databases node of the Analysis Services instance and select New Database.

  4. In the New Database dialog box, in Database name, type the name of the new database.

  5. In Impersonation, provide impersonation information for the new database.

  6. In Description, type the optional description for the new database.

  7. Click OK.