Check out the Pentaho Performance Monitoring Plugin

The plugin is an open source project that helps Pentaho BI Administrators visualize performance statistics.

Examples include:

• The most frequently run MDX and SQL queries 
• Showing who uses the BI Portal most often 
• Measures for which queries take the longest time to execute 
• Many other statistics are captures and available as well as the examples above.