How To Cancel An MSAS Query

#1

Does anyone know if there is a way to programatically cancel an MDX query
submitted to MSAS. We would like to add a cancel button to the app to cancel
a query if it is taking a long time?

Also, is there any way to do this from a console like you could terminate a
user in SQL Server.

We are using SQL 2000 and MSAS Enterprise.

Thanks in advance

#2

Additionally, if there is a way to automatically cancel the query via a
predetermined timeout (for instance on the connection string) - i would also
be internerested in that solution.

"Kevin" wrote:

Quote:

Does anyone know if there is a way to programatically cancel an MDX query
submitted to MSAS. We would like to add a cancel button to the app to cancel
a query if it is taking a long time?

Also, is there any way to do this from a console like you could terminate a
user in SQL Server.

We are using SQL 2000 and MSAS Enterprise.

Thanks in advance

#3

You can only somewhat do this. See the section titled: "Monitoring User
Access" in the AS Operations Guide
http://www.microsoft.com/technet/pro.../anservog.mspx
With SQ2K5 we will support this capability natively.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Kevin" <kreester (AT) yahoo (DOT) com> wrote

Quote:

Additionally, if there is a way to automatically cancel the query via a
predetermined timeout (for instance on the connection string) - i would
also
be internerested in that solution.

"Kevin" wrote:

Does anyone know if there is a way to programatically cancel an MDX
query
submitted to MSAS. We would like to add a cancel button to the app to
cancel
a query if it is taking a long time?

Also, is there any way to do this from a console like you could
terminate a
user in SQL Server.

We are using SQL 2000 and MSAS Enterprise.

Thanks in advance

#4

Dave,

Thanks for your help - sort-a is right - it'll work, but it's a little
complicated for the average joe.

Can you point me to how to do this in the SQL 2005 Beta or at least a place
to look in the documemtation.

Thanks,
Kevin

"Dave Wickert [MSFT]" wrote:

Quote:

You can only somewhat do this. See the section titled: "Monitoring User
Access" in the AS Operations Guide
http://www.microsoft.com/technet/pro.../anservog.mspx
With SQ2K5 we will support this capability natively.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Kevin" <kreester (AT) yahoo (DOT) com> wrote in message
news:F90A29ED-CCC0-43C4-A20C-37F2D53E4292 (AT) microsoft (DOT) com...
Additionally, if there is a way to automatically cancel the query via a
predetermined timeout (for instance on the connection string) - i would
also
be internerested in that solution.

"Kevin" wrote:

Does anyone know if there is a way to programatically cancel an MDX
query
submitted to MSAS. We would like to add a cancel button to the app to
cancel
a query if it is taking a long time?

Also, is there any way to do this from a console like you could
terminate a
user in SQL Server.

We are using SQL 2000 and MSAS Enterprise.

Thanks in advance

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

How To Cancel An MSAS Query

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

How To Cancel An MSAS Query - 03-17-2005 , 10:03 AM

RE: How To Cancel An MSAS Query - 03-17-2005 , 04:19 PM

Re: How To Cancel An MSAS Query - 03-18-2005 , 07:56 PM

Re: How To Cancel An MSAS Query - 03-19-2005 , 07:05 PM