Using Excel to retrieve OLAP cube info
This is a discussion on Using Excel to retrieve OLAP cube info within the SQL Server Data Warehousing forums, part of the Microsoft SQL Server category; --> I might be way off but I would try and install pivot table services, PTSlite.exe off the SQL CD. ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 05:06 PM
| ||||
| ||||
 Using Excel to retrieve OLAP cube info I might be way off but I would try and install pivot table services, PTSlite.exe off the SQL CD. It has helped me work out client issues in the past. HTH Ray Higdon MCSE, MCDBA, CCNA >-----Original Message----- >I am the Data Warehousing developer and can open an .oqy >file in Excel 2000 but when I send the file to another >user he cannot. He uses many other files of this type >(Excel 2000 based on OLAP cubes) but for this he receives >the following message: > >Excel was unable to get necessary information about the >cube. The cube might have been reorganised or changed on >the server. > > > >. >      |
Linear Mode
