In short, "Dynamic MDX Queries" don’t work as described in the BOL.
I’ve lifted the sample code directly, tried to run it, and it fails.
It’s documented at http://msdn.microsoft.com/en-us/library/ms172589(SQL.90).aspx
The “Analysis Services Event Provider” queries a SQL table, ...