troubleshooting Question

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

Avatar of bateg
bateg asked on
Microsoft SQL ServerDB Reporting Tools
4 Comments1 Solution421 ViewsLast Modified:
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.
ASKER CERTIFIED SOLUTION
lcohan
Database Analyst
Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros