In this postI show how you can use StreamInsight to take events coming from SQL Server Profiler in real-time and do some analytics whilst the data is in flight.  Here is the solution for that post.  The download contains

1. Project that reads events from a previously recorded trace file
2. Project that starts a trace and captures events in real-time from a custom trace definition file (Included)

It is a very simple solution and could be extended.  Whilst this example traces against SQL Server it would be trivial to change this so it profiles events in Analysis Services.

Enjoy.