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 |
scottrell
Starting Member
1 Post |
Posted - 2004-04-06 : 15:53:10
|
Is there a way to join databases to view in a cube? |
|
SQLboom
Yak Posting Veteran
63 Posts |
Posted - 2004-04-23 : 02:17:29
|
did u get anything for this! |
|
|
Joozh
Posting Yak Master
145 Posts |
Posted - 2004-04-23 : 05:57:01
|
Hi,There might be a better approach but here's my suggestion:Why don't you use the 'ETL' concept and extract the required data from the different tables (of the different databases) and bring it into a new database and then in that new database do the rest...Hope this provides you with some clues. Nevertheless I would really like to hear an expert opinion on this since I myself am quite new to the DW/OLAP world ;)Regards.Thanks & Regards.-J |
|
|
|
|
|