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)
 Consolidation of 13 databases for OLAP Services

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-09-04 : 11:20:31
Bernil writes "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."
   

- Advertisement -