468,505 Members | 1,729 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,505 developers. It's quick & easy.

How to connect to a MSSQL 2000 OLAP Server

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.


Jul 20 '05 #1
0 1455

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Jack Smith | last post: by
reply views Thread by NPC403 | last post: by
reply views Thread by fmendoza | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.