Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Can Analysis services be installed on top of SQL Server 7.0?
Hi all... The Analysis Server can be installed by itself, that is, it didn´t need the SQL Server 2000 to be installed. So I think that you can install the Analysis Server in a machine that already has the sql server 7.0 running. I didn´t tried yet, but I´m not seeing what could going wrong... -
OLAP vs. Analysis Services
Hi people. I made this trasition in a company I work and everything went smoothly. the only thing I need to do was: - Make backups of the OLAP Databases. - Install the servers - Restore the backups In that process even the roles worked fine. So I don´t think that anyone of you will... -
OLAP/Excel 2000 Connection Problem
Hi Robert. Did you already install the ADO package in the machine you're trying to use the pivot table service? Sometimes this could be the problem. So if you already had installed it, try again with a newer version. Hoping that this could help, Wagner -
Connecting to Microsoft Olap cubes from ASP thru OLE DB/MSOLAP
Hi all... I'd experienced this problem too... I think that other guys replied the answer to the forum already, but... The problem is that you have to define a Role on the OLAP Manager wich contains the users you want to access the OLAP Cube, and after that, connect that role with your cube... -
Acessing OLAP via Pivot Table on the Web
Hi everybody... I'm experiencing a problem. I'm using the MS office pivot table component to access an OLAP cube via web. In an intranet environment it's ok, but when I try to access the cube from the internet, the page gives me the following message: Could not connect to the data source...
