<div>
<div class="content wysiwyg-content">
How &nbsp;can I limit the time duration of a query on an OLAP cube in Excel?<br />
when a user runs a query on a cube olap in a excel, I want limit to 30 seconds the time of the duration of the query, and I want produce a time out error.<br />
<br />
any idea?<br />

</div>
</div>


How  can I limit the time duration of a query on an OLAP cube in Excel?
when a user runs a query on a cube olap in a excel, I want limit to 30 seconds the time of the duration of the query, and I want produce a time out error.

any idea?


Limit time duration of a query on an OLAP cube in Excel

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.