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 7

By William Pearson

Re-Align the New Analysis Services Database to Use the Enhanced Source Database

The final step of preparatory step for adding relative time capabilities to the Warehouse cube clone is to point the new Analysis Services database to the enhanced Access database. Recall that our modified database contains structural elements to support the relative time dimension.

We can accomplish this source re-alignment with the following steps:

1.  Expand the new Relative Time Sample database by clicking the "+" sign to its left.

2.  Expand the Data Sources folder that appears, just below the expanded Relative Time Sample database.

3.  Right-click the FoodMart data source that appears.

4.  Select Edit from the context menu that appears, as depicted in Illustration 30.

Click for larger image

Illustration 30: Editing the Data Source

The Data Link Properties dialog appears, defaulted to the Connection tab. Since we are simply re-pointing to another MS Access database, we will only need to make minimal changes at this level.

5.  Type the following into the bottom selector box on the dialog, just under the title "3. Enter the initial catalog to use":

D:\Program Files\Microsoft Analysis Services\Samples\RelativeTimeSample

NOTE: If you placed your copy of the database in another location, type in the correct location here, instead.

6.  Click Test Connection to ascertain connectivity.

A Data Link message box appears, indicating that the Test connection succeeded.

NOTE: An error here likely means an incorrectly typed path. See the steps above if this is the case.

7.  Click OK to dismiss the message box.

The Data Link Properties dialog, Connection tab, appears as shown in Illustration 31.

Illustration 31: Our Modifications to the Data Link Properties Dialog – Connection Tab

8.  Click OK on the Data Link Properties dialog to accept changes and close it.

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