Avatar of bateg
bateg

asked on 

How can I create OLAP report that could retrieve data from two different servers ?

I have two different servers, and I would like to create report that could combines data from two different databases each located in a different server.
Please note that the DB structure is identical but the data stored in each db is different, for example we have HR employees data is stored in Server 1 & Marketing employees data is stored in Server 2, different Employee_ID of course, the report should have both employees data (as measures) and the Employee_ID as a shared dimension, but I don't know how to do that.

We are using SQL server 2000 & analysis services enterprise edition SP4.
Microsoft SQL ServerDB Reporting Tools

Avatar of undefined
Last Comment
bateg

8/22/2022 - Mon