the Database to Support a Relative Time Dimension in the Cube
create a couple of objects within our new MS Access database to support relative
time periods within the sample cube we will use later in our exercises.
Again, we are doing this in MS Access to leverage existing samples and save
time – the concepts are similar, although methods vary somewhat, in the more
robust MSSQL Server environment.
Open the RelativeTimesample.mdb
in MS Access (I'm using Access 2003 in my illustrations, but Access 2000 and
beyond will work, and will be very similar in operation).
Get to the Database
View for the database.
Click the New
button atop the view, as depicted in Illustration 8.
View from the New Table dialog that appears, as shown in Illustration
Illustration 9: New
Table Dialog: Select Design View
View for the new
information presented in Table 1 into the designated places in the Design
Table 1: Creating a New Table - Design View
View for the new
table appears as partially depicted in Illustration 10.
Illustration 10: The New
Table in Design View (Partial View)
--> Datasheet View from the main menu, as shown in Illustration
Illustration 11: Shift
to Datasheet View
appears, stating that we must save the table first.
to save the table, as
depicted in Illustration 12.
Illustration 12: Notice
to Save the Table First ...
following into the Save As dialog that next appears:
completed Save As dialog for the new table appears, as shown in Illustration
Illustration 13: Saving
the New Table in the Sample Database
Click OK to
save the table and close the Save As dialog.
Click No on
the next dialog to appear, to pass on creating a Primary Key in this
practice instance, as depicted in Illustration 14.
Illustration 14: Just
Say "No" to Creating a Primary Key ...
opens in Datasheet View.
information assembled in Table 2 into the designated columns of the
table within Table View.
Table 2: Inserting Data into the Table - Datasheet View
appears in the second row when we type the "1" into the first row.
View for the table
appears as shown in Illustration 15.
Illustration 15: The New
Table in Datasheet View (Partial View)
--> Close from the main menu to close the
table and return to Data View.
The new relativetime
table appears among the other tables, in Data View for the database,
as depicted in Illustration 16.
Illustration 16: The New
Table Appears in Database View