Re: Access OLAP over Web-browser, serverside

#1

Hi Chris,

My API of choice for Analysis Services is XML for Analysis. I am
about to publish a new article on my ThinOLAP blog
(www.activeinterface.com/thinolap/thinolap.asp) where I will move the
logic to the server-side. Until then (probably next week for the
server-side article), you can check out the current articles and get
familiar with XML/A, which will become the native API for AS in the
next version of SQL Server.

Chris

"Chris" <c.huter (AT) mobilkom (DOT) at> wrote

Quote:

Hi !

Can you help me ?
I want to build a web-application that builds an MDX Query according
to input parameters and displays the results in a normal HTML Table.
The server is an MS-SQL OLAP.

Yet, I can connect to the OLAP cube via VB and with MS Pivottable
client-side over Web.
With ASP my code fails, because it cannot find the database:
Set db = Server.CreateObject("ADODB.Connection")
db.Open "Provider=MSOLAP;Data Source=myServerName;Initial
Catalog=myDatabaseName"
Here i reason i have to give username and password in the connection string,
but do not know how.
Just adding username=MyUserName;password=MyPassword does not work.

I am also open towards a solution with JSP, as long as it works with MS SQL
OLAP.
I would also welcome any recommendation for a good book that focuses on OLAP
development.

best regards,
Christoph Huter
c.huter (AT) mobilkom (DOT) at

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Access OLAP over Web-browser, serverside

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Re: Access OLAP over Web-browser, serverside - 08-22-2003 , 09:50 PM