Reporting services

Is it possible to generate ad hoc reporting in reporting services from an analysis services database? I would like to be able to generate ad hoc models for use in report builder. Does anyone know if this is possible?

Yes, you can generate RB model for AS cube - just right-click on UDM data source in Reporting Services connected in management studio, as described for example here.

My personal experience is, that RB is good for simple ad hoc queries, but when you will want to do anything more complex, use some advanced filter or grouping, then you're lost. Also, RB doesn't generate the most efficient MDX code, so performance suffers as well. We've tested it for some time, but at the end we decided to use Proclarity.

Radim