Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
heze
Posting Yak Master
192 Posts |
 Posted - 2007-05-25 : 08:55:41
|
| hi I have 2 questions,1-Is there a way to create an mdx statement inside a stored procedure so that instead of having my .net application connect to analysis services have SQL Server do that for me?2-If possible, is it possible to create and exec() dynamic mdx inside the stored proc?thank you |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-25 : 09:57:00
|
| Don't think so. |
 |
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2007-05-25 : 11:14:54
|
You should be able to do this using the OLE DB Provider for Analysis Services and OPENROWSET/OPENQUERY. I.e. Select * FROM OPENROWSET('MSOLAP', 'Data Source=<ASServer>;Initial Catalog=<ASDB>;', '<MDXQuery>')Mark |
|
|
|
|
|
|
mdx in sql stored procedure