Proactive Business Intelligence (BI)

In the past, most organizations would build data warehouse to archive the huge volumne of transactional data that are generated each day. IT folks would then build data cubes using these day, and the cube would then provide business/market analysts with the ability to analyze the market (E.g. revenue per business segment, quaterly financial results, etc).

Several issues arises:
a) By the time the analyst analyzes the data using the cube, business events would have passed (e.g. customer churned! )
b) Third-party tools are often use to build the cube. These third-party tools would often provide their own propritary cube viewers. Reports are then exported from these viewers to excel
c) IT folks would somtime build self-service reporting solutions for the business users to generate their own reports.

In (a), I refer to this as Passive Business Intelligence. It would be nice if the business/market analysts could be alerted even before the business events happen, and then re-act to this, and anticipate customer needs. I refer to this as Pro-active Business Intelligence. Can we achieve this easily?

Is there a solution that is out-of-box and can tackle also (b) and (c)?

I believe with SQL Server 2005 and its list of data mining algorithms, we can achieve Proactive BI!