Just a little question... should i have MS-query to use OLAP Pivot table
Services in Excel 2000? or should i only install PTSfull.exe?

Thanks

Rodrigo

I'm not sure about ms-query...you don't do anything in the ms-query
program - you just pick a tab page saying connect to olap cubes instead of
starting ms-query so i don't think so.

but you need pts - either ptslite i think or ptsfull as you say. and this
needs to be the same sp version as the server in order to avoid
problems....so if you have sp3a on server take the pts from this sp.


"Rodrigo" <Rodrigo (AT) discussions (DOT) microsoft.com> wrote

MSQuery is required to access OLAP cubes in Excel, because Excel relay to
the MSQuery subsystem to display the connection dialog box.
I have not tested if you open an excel file already connected to a cube. In
this case, the MS Query could be optional.


"Rodrigo" <Rodrigo (AT) discussions (DOT) microsoft.com> wrote

uhmm... I did the next test:
I renamed the MSQuery .EXE file (MSQRY32.EXE) and then built the next macro:

Sub Test1
With ActiveWorkbook.PivotCaches.Add(SourceType:=xlExter nal)
.Connection = "OLEDB;Provider=MSOLAP.2;Data
Source=LICANCABUR;Initial Catalog=MIS;Client Cache Size=25;Auto Synch
Period=10000"
.CommandType = xlCmdCube
.CommandText = Array("Resultado_Colocaciones")
.MaintainConnection = True
.CreatePivotTable TableDestination:=Range("A3"), TableName:= _
"Colocaciones"
End With
end sub

and... surprise, it worked...

So it seem that PTS don`t need MSquery to work...

Regards

Rodrigo

*************
"Jéjé" wrote:

exactly, PTS don't need msquery
msquery is just required to create a new connection from Excel himself, not
by code.


"Rodrigo" <Rodrigo (AT) discussions (DOT) microsoft.com> wrote