MDX in a stored procedure in 2008

Question

MDX in a stored procedure in 2008

Tobar

SSCarpal Tunnel

Points: 4876
More actions
August 22, 2011 at 9:16 am

#390237

Is there any way to put MDX in a stored procedure that can be called by a web front-end? I don't see anything about it in Google or here, but I am not sure I am asking the correct question.
<><
Livin' down on the cube farm. Left, left, then a right.

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

bhushan_juare Ten Centuries Points: 1292 More actions · Answer 1

This is not possible using stored procedure but same thing can be achieved using .net Script i.e. passing SSAS Connection String consisting of mdx in that script.

Check the below links

http://businessintelligence.com/article/52

drew.allen SSC Guru Points: 77014 More actions · Answer 2

bhushan_juare (8/23/2011)
This is not possible using stored procedure

I've never done it, but this link claims that it is possible.

http://social.msdn.microsoft.com/forums/en-US/sqlanalysisservices/thread/d6052ef3-a5ce-46b2-a15e-c3200186fe55

Drew

J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

Tobar SSCarpal Tunnel Points: 4876 More actions · Answer 3

Thanks to these are the options we will work with.

<><
Livin' down on the cube farm. Left, left, then a right.

bhushan_juare Ten Centuries Points: 1292 More actions · Answer 4

I had tried this linked server method but that didnt work...