Introduction to MSSQL Server Analysis Services: Migrating an Analysis Services 2000 Database to Analysis Services 2005 - Page 3

November 21, 2005

Verification: Examine the Migrated Database in SQL Server Management Studio

The first place we will review our migrated database will be from our current position within the SQL Server Management Studio.

1.  Expand the Databases folder that appears in the Object Explorer pane, underneath the Analysis Services server within which we are working, on the left side of the Management Studio.

The Analysis Services databases in our local environment appear.

2.  Select View --> Refresh, as depicted in Illustration 10, if the newly migrated FoodMart 2000 database does not appear immediately.

Illustration 10: Refresh the Object Explorer as Necessary ...

The Analysis Services databases in our local environment appear, including the new FoodMart 2000 database, similar to those shown in Illustration 11.

Illustration 11: FoodMart 2000 Appears Among the Analysis Services Databases

3.  Expand the new FoodMart 2000 database.

4.  Expand the Cubes folder.

We can easily review the entire structure of the database here, simply by expanding the database, and subsequently expanding the underlying folders, as depicted in Illustration 12.

Illustration 12: Objects Making Up the Migrated FoodMart 2000 Database ...

5.  Right-click the Sales cube in the FoodMart 2000 database Cubes folder.

6.  Select Properties from the context menu that appears, as shown in Illustration 13.

Illustration 13: Open the Properties Page for the Sales Cube

The Properties page for the Sales cube appears, as depicted in Illustration 14.

Illustration 14: Example Properties Page for a Database Object

We can examine the underlying properties of each of the cube and other database objects in this fashion. While we can make modifications, deletions and so forth within the Management Studio, the Business Intelligence Development Studio is often the better option for design and development within the context of an integrated business intelligence solution, whether working with a migrated Analysis Services database, or creating such a database from scratch.

7.  Click OK to close the Properties page.

Let's go to the Business Intelligence Development Studio next, and get an introduction in opening our newly migrated database there.

8.  Select File --> Exit from the main menu, as shown in Illustration 15, to close the SQL Server Management Studio.

Illustration 15: Leaving SQL Server Management Studio ...