Avoid deadlock in SSAS by preventing querying during process
<p>I have a <strong>SSAS cube</strong> which is <strong>processed</strong> on a regular basis to integrate newly available data in source tables.</p>

<p>The issue is that sometimes it seems that the process interferes with some heavy queries causing <strong>locking conflicts</strong>. (one every 2 weeks)</p>

<p>How can I avoid that?</p>

<p>Is there a way to prevent SSAS from executing queries while it is processing the cube?</p>

<p>This should not impact performance too heavily as the processing time is quite short in general.</p>

<p>Moreover redesigning the cube to enhance performance and reduce the odds of this issue happening is not an option.</p>