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 Jun 21, 2004

Introduction to MSSQL Server 2000 Analysis Services: Another Approach to Local Cube Design and Creation - Page 3

By William Pearson

Starting with the Relational Data Source

Let's get started with defining the rowset upon which the cube will be based. We will keep the structure fairly simple to allow us to focus on design and creation concepts as we proceed.

1.  Open a new Microsoft Excel ("Excel") worksheet.

2.  Select Data from the top menu.

3.  Select Import External Data from the dropdown menu.

4.  Click New Database Query from the cascading menu, as shown in Illustration 1.

Click for larger image

Illustration 1: Initializing the Database (Rowset) Query

MS Query is initialized, and the Choose Data Source dialog appears.

5.  On the Database tab of the dialog (the default when the dialog appears), choose Microsoft Access Database.

We leave the Query Wizard enabled, via the default setting on the dialog - the checkbox - to assist in guiding us through the design process.

The Choose Data Source dialog appears, with our selection, as depicted in Illustration 2.

Illustration 2: The Choose Data Source Dialog for Microsoft Query

6.  Click OK.

The Select Database dialog appears, along with a Connecting to Data Source progress dialog, as shown in Illustration 3.

Illustration 3: The Select Database Dialog

7.  Find and select the FoodMart 2000 Access database (FoodMart 2000.mdb), which is typically installed in the Samples folder of the Microsoft Analysis Services directory under Program Files on the drive upon which the Typical installation took place (in my case, for example, the .mdb is located at D:\Program Files\Microsoft Analysis Services\Samples).

The Select Database dialog, with our selection, appears as that depicted in Illustration 4:

Illustration 4: The Select Database Dialog

8.  Click OK.

The Query Wizard - Choose Columns dialog appears.

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