If it was 2008, I would be pushing for Report Builder access as this got a lot better in 08 for AS cubes. Seeing at it's 05, then I'd prob look at having someone build the Reporting Services report and then publish it up for your users. If you've got MOSS 07 and you're looking to push a lot of the access to the intranet, then I'd skip the RS for all of the adhoc and use the published Excel web parts for dynamic end user querying. It's a hard call in this case (based on what we know of your situation) as for this particular requirement, you should be able to solve it using SSRS, however do you want to deliver *all* content via (developer created reports in) SSRS? Probably not.