I'd like to share a new article on how to trace SQL generated byMondrian ROLAP engine :
http://pentaho-en.phi-integration.com/bi-server/how-to-trace-sql-generated-by-mondrian
Hope it helps us !
Regards,
Feris