Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2003
    Posts
    7

    Unanswered: Problem with Excel 2000 and OLAP

    Ciao,
    I have created some cubes in my Analysis Server (SQL2000
    Server) and try to retrieve the cube data by Excel2000.
    In my own computer, when I create the data source in Excel, I
    have not the options for "Microsoft OLE DB Provider for OLAP
    Services" and "Microsoft OLE DB Provider for OLAP Services
    8.0".

    I have installed the Analisys Services..

    Can anyone help? Thanks!

    Fabrizio

  2. #2
    Join Date
    Mar 2003
    Location
    Kuala Lumpur, Malaysia
    Posts
    6

    Problem with Excel 2000 and OLAP

    Hi Fabrizio,

    below is the step i use retrive cube data from excal 2000.

    1) in Excel 2000 click Data --> PivotTable and PivotChart Report
    2) in pivot wizard step 1, choose external datasource.
    3) click get data
    4) click <new datasource> at OLAP CUBE tab
    5) select OLAP Provider.
    6) select Microsoft OLE DB Provider for Olap Services 8.0
    7) click connect --> analysis server --> enter server name
    8) it should display a list of OLAP database, select your database & cube.

    cheers,
    suhfui

  3. #3
    Join Date
    Mar 2003
    Posts
    7

    Re: Problem with Excel 2000 and OLAP

    Sorry but I haven't Microsoft OLE DB Provider for Olap Services 8.0.
    Why?

    Thank you

  4. #4
    Join Date
    Feb 2003
    Location
    Germany
    Posts
    21

    install PTSFull on client machine

    You need to install PTSFull (Pivot Table Services) on your client as well.

    It can be found in SP3 for Analysis Services in the folder

    sql2kasp3\msolap\install\PTS


    the 8.0 version is available after that.

    HTH Lutz

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •