Search
InstantDoc ID
GO

Browse By: Author | Issue

September 21, 2000 04:21 PM

Building a Cube from a Dimensional Database

Rating: (0)
Bob Pfeiff
SQL Server Magazine
InstantDoc ID #9709
Preaggregate data for fast query performance
Need a solution that lets you answer business questions flexibly and extensively? You can design, build, and populate a dimensional database, or data mart, from a relational database to support basic reporting requirements. In "Relational to Dimensional," June 2000, I created a dimensional database called Northwind_MD, using SQL Server's Northwind sample database as the source for operational data and a Data Transformation Ser...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Compare Member Benefits

Add a Comment

Good article. I understand the role of Analysis Services much better now. Thanks.

Anonymous User 12/10/2004 8:04:52 AM

I can't find / download 9709.zip file (containing DTS). When I search for DocID 9709 it shows the existing page.

Sankaranarayanan A 2/24/2003 5:15:55 AM

I am trying to register an Analysis server. I can easily install the analysis manager but no instances of SQL Server are accepted and I can't find the OLAP Administrators group.
I would appreciate some tips.
Thank you

J Gama 10/9/2001 2:39:12 PM

I tried to execute the DTS package with VB6 and got an error:
EXCEPTION_ACCESS_VIOLATION
I never used DTS before and so I don't know where to go from here. Is there any way to populate the database with that file directly from SQL Server?
Thank you.

J Gama 10/8/2001 6:19:10 PM

Printer friendly version not so printer friendly. Your tables are too wide to properly fit on a standard sheet of paper when printing. I have tried printing from multiple PC's on multiple printers with the right hand margins always exceeding the paper. This means the article gets cut off and ends up meaning the printerfriendly version is useless. Please fix!!!
Spencer Tabbert

Spencer Tabbert 4/12/2001 9:51:53 AM

You must log on before posting a comment.

Are you a new visitor? Register Here

Related Content

GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS

© 2010 Penton Media, Inc.

Windows is a trademark of the Microsoft group of companies. Windows IT Pro is used by Penton Media Inc. under license from owner.