Google
 

Thursday, December 11, 2008

Nugget: Stop a rule in PerformancePoint while running

When you run rules, there is no option to cancel in the Business Modeller.  There are a few solutions for killing rules while running.

1. Kill the SQL process (sp_who2, kill ##) of the rule. (SQL implementation)

2. Kill the Analysis Services process of the rule. http://www.codeplex.com/MSFTASProdSamples.

3. IISReset.

4. SQL / SQL Analysis Services Reset.

5. (Possibly) kill w3wp.exe process.

All are brute-force methods highlighting the fact that you are probably not meant to stop rules while they are running. :)

Welcome to the PerformancePoint Planning Business Rules Development Guide

No comments: