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 Sep 20, 2004

Introduction to MSSQL Server 2000 Analysis Services: Basic Storage Design - Page 3

By William Pearson

Hands-On Procedure


We will prepare for our practice example by opening MSAS Analysis Manager, and creating a copy of the HR cube, upon which to run the Storage Design Wizard. Keep in mind, as we progress, that we are working with a small cube with no pre-existing aggregations.

1.  Start Analysis Manager.

2.  Expand the Analysis Servers folder by clicking the "+" sign to its immediate left.

Our server(s) appear.

3.  Expand the desired server (mine appears as MOTHER1 in the illustrations).

Our database(s) appear, in much the same manner as shown in Illustration 1.

NOTE: The objects appearing in your environment will differ, in general, from mine, and depend upon the actions you have performed since initially installing MSAS.

Illustration 1: Sample Databases Displayed within Analysis Manager

4.  Expand the FoodMart 2000 database.

5.  Expand the Cubes folder.

The sample cubes appear, as shown in Illustration 2.

Illustration 2: FoodMart 2000 Database Sample Cubes

6.  Right-click on the HR sample cube.

7.  Select Copy from the context menu that appears, as shown in Illustration 3.

Illustration 3: Selecting Copy from the Context Menu

8.  Right-click on the Cubes folder.

9.  Select Paste from the context menu that appears, as shown in Illustration 4.

Illustration 4: Selecting Paste from the Context Menu

The Duplicate Name dialog appears.

We cannot have two cubes of the same name in a given MSAS database.

10.  Type the following into the Name box of the Duplicate Name dialog:


The Duplicate Name dialog appears, with our modification, as depicted in Illustration 5.

Illustration 5: The Duplicate Name Dialog, New Name Inserted


This is also a good way to rename MSAS objects for which a "Rename" option does not exist. In "rename" scenarios, we simply create the new object in the manner shown above, give it the desired name, and discard the original object, as appropriate.

Keep in mind that, in the case of cubes and other structural objects, this will likely mean reprocessing before the clone will be fully usable.

11.  Click OK to save the name change.

The new cube appears in the cube tree, among those already in place. We now have a copy of the HR cube, DBJ_STORDESIGN, upon which we can work with the Storage Design Wizard.

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