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.

 All Forums
 SQL Server 2000 Forums
 Analysis Services (2000)
 joining databases

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!
Go to Top of Page

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
Go to Top of Page
   

- Advertisement -