Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-01-18 : 18:07:16
|
| 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 Post |
Posted - 2002-08-29 : 10:32:54
|
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. |
 |
|
|
Teroman
Posting Yak Master
115 Posts |
Posted - 2002-08-29 : 10:55:56
|
| 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 etcOne 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 startedcol |
|
|
|
|
|
|
|
|
Article: Dimensionally Friendly System