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.
Manager, beginning at the Start menu.
Expand the Analysis
Servers folder by clicking the "+" sign to its immediate
database(s) appear, in
much the same manner as depicted in Illustration 24.
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.
FoodMart 2000 database.
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.
from the context menu that appears.
the Analysis Server.
from the context menu that appears, as shown in Illustration 25.
Illustration 25: Paste
the Cloned Database to the Analysis Server
Name dialog appears.
in previous articles, we cannot have two databases of the same name in a given
following into the Name box of the Duplicate Name dialog:
Relative Time Sample
Name dialog appears, with our modification, as depicted in Illustration 26.
Illustration 26: The
Duplicate Name Dialog, with New Name
TIP: As I have mentioned elsewhere,
in this and other series, the foregoing is also an excellent way of renaming
a cube (a "rename" capability is not available here, as it is in
many Windows applications). Simply create a duplicate, give it the name to
which you wish to rename the old cube, and then delete the old cube, as
appropriate. This also works for Analysis Services databases, dimensions
and other objects.
to apply the name change.
database, Relative Time Sample, appears in the tree beneath the Analysis
Server, among the databases already in place, as shown in Illustration 27.
Illustration 27: The New
Database Appears ...
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"
Process the Copy
1. Right-click the new Relative Time Sample database.
2. Select Process the
Database from the context menu that appears, as depicted in Illustration
Illustration 28: Select
Process the Database from the Context Menu
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.
Illustration 29: Indication
of Successful Completion Appears (Compact View)
to dismiss the viewer.
next take the final preparation steps for establishing relative time
capabilities within the Warehouse cube.