In SQL 2000 if I install the client tools on a client then they have an easy interface to access the server. What about the OLAP services? I installed the OLAP client tools on the client and I could see nothing that was clearly used to give the client the same level of usability as that which is for SQL Server or that is on the machine that is hosting the OLAP services.. Thanks.

--
George Hester
_________________________________

You need a front-end on the client - this front-end could be

a) microsofts own components such as pivottable in excel, owc (office web
components) on a web page or the excel-add in

or...

b) a third-party front-end (need to buy one such as reportportal,
proclarity, panorama)

or...

c) code your own using mdx + asp

The SQL Server cd is server tools - however - if you want to design access
from thick clients on the client you need to install PTSFULL of PTSLITE
(will be on the cd) and remember to add sp3a on both sql-server and on
analyiss services. Also remember that on the CD you need to install SQL
Server on the server and also install Analysis Services on the server - bot
are server tools.

"George Hester" <hesterloli (AT) hotmail (DOT) com> wrote

In SQL 2000 if I install the client tools on a client then they have an easy
interface to access the server. What about the OLAP services? I installed
the OLAP client tools on the client and I could see nothing that was clearly
used to give the client the same level of usability as that which is for SQL
Server or that is on the machine that is hosting the OLAP services..
Thanks.

--
George Hester
_________________________________

Thanks Michael. I just ran the SQL 2000 Enterprise CDROM on both Server (to get the Server) and again on
the client to get the client tools.

I have upgraded everything to SP3 and beyond. Don't trust 3a.

Now the ptsfull or ptslite I am unaware of ptslite it is on the SQL CDROM? And I should run that on the client? Where is ptsfull? Thanks.

--
George Hester
_________________________________
"Michael Vardinghus" <michaelvardinghus (AT) hotmail (DOT) com> wrote

The client tools related to olap isn't just something on the sql server cd -
client tools is excel (data, pivottable, external data source, olap)

The client tools on the server cd-rom (pts) is just so that the front ends
on your client are able to comunicate with the latest sql server version.

Ptsfull and light on the cd-rom...but use the one with servicepack 3a....

http://msdn.microsoft.com/library/de...us/olapdmpr/pt
_intro_4fhv.asp
http://support.microsoft.com/default...rvicepacks%2FS
QL%2F2000%2FSP3ReadMe.asp

"George Hester" <hesterloli (AT) hotmail (DOT) com> wrote

Thanks Michael. I just ran the SQL 2000 Enterprise CDROM on both Server (to
get the Server) and again on
the client to get the client tools.

I have upgraded everything to SP3 and beyond. Don't trust 3a.

Now the ptsfull or ptslite I am unaware of ptslite it is on the SQL CDROM?
And I should run that on the client? Where is ptsfull? Thanks.

--
George Hester
_________________________________
"Michael Vardinghus" <michaelvardinghus (AT) hotmail (DOT) com> wrote

Hi. Well I tried installing ptslite both on the Server that is running the OLAP services and on the client which I am hoping to attach to an OLAP service. Both errored saying cannot install for the Parent Analysis Server is already installed. OK I guess what I could use is a sample test to see if I can access the OLAP services on the Server from the client. The client doesn't have Excel on it. That would probably be necessary huh? Not a problem just haven't installed it yet can't make up my mind what version of Office to install in there.

--
George Hester
_________________________________
"Michael Vardinghus" <michaelvardinghus (AT) hotmail (DOT) com> wrote