Well I installed my first OLAP Server ever just yesterday, allright.
I built my first cube with a data source from a MSSQL Server 2000 on the
same machine, allright.
I browsed the cube with Analysis Manager, allright.
Then , my real goal:
I want to connect to OLAP Server in much the same way as I use to do with
SQL Server, that is from my Domino Web Server, through Lotus Connectors over
OLE DB provider. I thought I just needed to adapt my sql statements....
Can this be done?

I mean, I learnt about MDX, but can I run MDX queries (and get resultsets,
of course) against an OLAP server with some APIs? Or can I run MDX query
from inside the Query Analyzer in SQL Server, using the OLAP Server as a
linked server (with openquery statement)?

Well, I'm quite confused at the moment, so excuse me if I didn't provide all
the necessary details, and TIA.

Moco

OLAP has it's own data provider (comparable with ADO). It is called
Microsoft ActiveX Data Objects (Multi Dimensional) or ADOMD for short.

There is also the OLEDB Provider for OLAP Services.

--
Jacco Schalkwijk
SQL Server MVP


"Moco" <moco (AT) proxSPAMYOURSISTERimanet (DOT) it> wrote

can be done via ADOMD or XML/A. Your biggest issue will be authentification
between Domino Web Server and the OLAP server.

dlr

"Moco" <moco (AT) proxSPAMYOURSISTERimanet (DOT) it> wrote

Thanks to all for quick responses.
I think I'll have a look at OLEDB provider for OLAP.

"Moco" <moco (AT) proxSPAMYOURSISTERimanet (DOT) it> wrote