SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Site Related Forums
 Article Discussion
 Article: Dimensionally Friendly System
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

AskSQLTeam
Ask SQLTeam Question

USA
0 Posts

Posted - 01/18/2001 :  18:07:16  Show Profile  Visit AskSQLTeam's Homepage  Reply with Quote
How the Microsoft SQL Server 2000 Data Warehouse technologies map to the twenty criteria for a Dimensionally Friendly System, as characterized by Ralph Kimball.

Article Link.

bed_decipher
Starting Member

1 Posts

Posted - 08/29/2002 :  10:32:54  Show Profile  Reply with Quote
Hello I am currently working in an organization of companies. I was given a task to use the OLAP features of SQL Server 7.0 for our company. I would like to ask a question. My question is that " Is it possible to combine 13 databases which have almost the same tables to consolidate a report? Or in making a cube is it possible that these 13 databases is only dimension? We have different databases for each company and my boss wants that there is a summation of figures for these 13 databases." Please reply.


Go to Top of Page

Teroman
Posting Yak Master

United Kingdom
115 Posts

Posted - 08/29/2002 :  10:55:56  Show Profile  Send Teroman an AOL message  Reply with Quote
I think what you want to make is a data warehouse, a big database that holds all the data from all the sources in one place.

Next you would build cube(s) off of that source. The thing to do is to massage all your data into the same format before it gets into the datawarehouse.

You say that all the databases may be one dimension, sounds to me like a terminology problem. They would all feed one data warehouse, perhaps just one cube depending on the queries you want to run, could quite easily be more. This depends on your data structure, and what you want to find out from your data.

Dimensions are the things you want to chop the data up by, eg Time, Location, Product, Customer etc

One last thing, I would recommend strongly that you use Analysis Services, the OLAP tool that comes with SQL Server 2000, as it is FAR better than the verion 7 product.

hope this gets you started

col

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000