Hi,

ProClarity (http://www.proclarity.com) as a front-end tool that gives you both the capability of doing analysis, but also to integrate with Reporting Services.

Definitely worth to have a look at it.

Nick