Introduction to MSSQL Server Analysis Services: Mastering Enterprise BI: Relative Time Periods in an Analysis Services Cube, Part II - Page 6
July 11, 2005
Clone the FoodMart 2000 Sample Database
We will create a copy of the FoodMart 2000 sample database, which, along with the several cubes and other objects it contains, accompanies an Analysis Services installation. This will allow us to keep the original sample database intact for other uses.
1. Open Analysis Manager, beginning at the Start menu.
2. Expand the Analysis Servers folder by clicking the "+" sign to its immediate left.
Our server(s) appear.
3. Expand the desired server.
Our database(s) appear, in much the same manner as depicted in Illustration 24.
Click for larger image
NOTE: Your databases / cube tree will differ, depending upon the activities you have performed since the installation of MSAS (and the simultaneous creation of the original set of sample cubes). Should you want or need to restore the cubes to their original state, simply restore the database under consideration. For instructions, see the MSSQL Server 2000 Books Online.
4. Right-click the FoodMart 2000 database.
Again, we are making a copy of the database, because our lesson will involve making changes to the data connections, as well as the Warehouse cube and other objects, within the practice example. As we have noted, working with the copy will allow us to maintain our existing sample cube in its current condition, and available to other possible users and applications.
5. Select Copy from the context menu that appears.
6. Right-click on the Analysis Server.
7. Select Paste from the context menu that appears, as shown in Illustration 25.
The Duplicate Name dialog appears.
As noted in previous articles, we cannot have two databases of the same name in a given Analysis Server.
8. Type the following into the Name box of the Duplicate Name dialog:
Relative Time Sample
The Duplicate Name dialog appears, with our modification, as depicted in Illustration 26.
9. Click OK to apply the name change.
The new database, Relative Time Sample, appears in the tree beneath the Analysis Server, among the databases already in place, as shown in Illustration 27.
We now have a copy of the FoodMart 2000 database, within which we can perform the steps of our practice exercise. Let's process the new database to "register" it with Analysis Services, and to ensure that we are all in a "processed" state.
Process the Copy Database
1. Right-click the new Relative Time Sample database.
2. Select Process the Database from the context menu that appears, as depicted in Illustration 28.
Processing begins immediately, and the Process viewer appears, displaying various logged events. Processing completes, and the viewer presents a green Processing completed successfully message, as shown in Illustration 29.
3. Click Close to dismiss the viewer.
We will next take the final preparation steps for establishing relative time capabilities within the Warehouse cube.