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!
FabrizioHi 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|||Sorry but I haven't Microsoft OLE DB Provider for Olap Services 8.0.
Why?
Thank you|||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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment