Re: How to connect to a MSSQL 2000 OLAP Server
From: Dennis Redfield (dennis.redfield_at_acadia-ins.com)
Date: 09/24/04
- Next message: rachel.jones_at_talbotuw.com: "Banding in calculated measures"
- Previous message: Mathasu: "Re: How to insert a calculation of %"
- In reply to: Moco: "How to connect to a MSSQL 2000 OLAP Server"
- Next in thread: Moco: "Re: How to connect to a MSSQL 2000 OLAP Server"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 24 Sep 2004 08:57:55 -0400
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@proxSPAMYOURSISTERimanet.it> wrote in message
news:hRS4d.18374$Ie2.14837@tornado.fastwebnet.it...
> 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
>
>
- Next message: rachel.jones_at_talbotuw.com: "Banding in calculated measures"
- Previous message: Mathasu: "Re: How to insert a calculation of %"
- In reply to: Moco: "How to connect to a MSSQL 2000 OLAP Server"
- Next in thread: Moco: "Re: How to connect to a MSSQL 2000 OLAP Server"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
