Viewing an olap cube in excel

Posted on 2007-10-09
Last Modified: 2013-11-16
Hi There

I am trying to import external data in Excel from a OLAP cube.
I try and conect to the datasource and I keep getting a Unable to locate server error.

Is there anything that needs to be installed or configured on the server to allow this connection.
I am using SQL 2000 standard edition SQL 2000 analysis server.Office 2002 and windows server 2003
Question by:Stanton_Roux
    1 Comment
    LVL 6

    Accepted Solution

    You must have the PTS (Pivot Table Services) installed on your client PC (you can find the PTS on your SQL Server 2000 CD). The correct version of MDAC is also a requirement (min. 2.6 or 2.7).

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    I annotated my article on ransomware somewhat extensively, but I keep adding new references and wanted to put a link to the reference library.  Despite all the reference tools I have on hand, it was not easy to find a way to do this easily. I finall…
    This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
    Viewers will learn how the fundamental information of how to create a table.
    Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

    761 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

    11 Experts available now in Live!

    Get 1:1 Help Now