How to create linked cube using Analysis services ?

Posted on 2011-05-08
Last Modified: 2012-05-11
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 .
Question by:bateg
    LVL 15

    Accepted Solution

    read this :

    at the bottom you have links for creating and managing liked cubs.

    Author Closing Comment

    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

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now