The Design of Software (CLOSED)

A public forum for discussing the design of software, from the user interface to the code architecture. Now closed.

The "Design of Software" discussion group has been merged with the main Joel on Software discussion group.

The archives will remain online indefinitely.

Analysis Services (MS OLAP) Stored Procedures

Can anyone confirm or deny whether SQL Server Analysis Services (MS OLAP) has the equivalent of Stored Procedures in SQL Server.

I haven't been able to find anything which definitively states one way or the other.

My current understanding is that is does not support stored procs. My current (and only approach) is to pass MDX strings via ADOMD. My main objective is maintenance not performance.
Marcus from Melbourne
Wednesday, October 18, 2006
you can not compile mdx in the olap database. An option is to run mdx statements through the openquery function from a sql server stored procedure.
lonely consultant
Thursday, October 19, 2006
Sevenoaks Send private email
Thursday, October 19, 2006
Excellent - thanks for that..
Marcus from Melbourne
Thursday, October 19, 2006

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics
Powered by FogBugz