Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Jul 11, 2005

Introduction to MSSQL Server Analysis Services: Mastering Enterprise BI: Relative Time Periods in an Analysis Services Cube, Part II - Page 6

By William Pearson

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

Illustration 24: Example Databases Displayed within Analysis Manager

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.

Illustration 25: Paste the Cloned Database to the Analysis Server

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.

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.

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.

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" 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.

Illustration 28: Select Process the Database from the Context Menu

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.

Illustration 29: Indication of Successful Completion Appears (Compact View)

3.  Click Close to dismiss the viewer.

We will next take the final preparation steps for establishing relative time capabilities within the Warehouse cube.

MS SQL Archives

Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM