• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 445
  • Last Modified:

How to create linked cube using Analysis services ?

I have SQL server 2000 enterprise edition installed in two remote servers , I need to create an OLAP report that retrieves information from both cubes , I read that linked cubes can do that.
When I pressed new linked cube I named the linked cube and I pressed new data source when I typed the IP address of the other server, an error message appeared "can not connect to <the ip address of the server I typed> due to unspecified error "  , also I tried to press advanced but no use , I have no idea what is the problem , please note that this is the first time I try to create linked cube.

I am using SQL server enterprise 2000 & anaylsis services on both servers.
The OS is Windows server 2003 sp2 .
1 Solution
Aaron ShiloCommented:
read this :http://msdn.microsoft.com/en-us/library/aa216375(v=sql.80).aspx

at the bottom you have links for creating and managing liked cubs.
bategAuthor Commented:
The error I was having was solved by installing SP3 & 4 for Analysis services , apart from that the article was helpful concerning the linked cubes.

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now