We have a large number of (Crystal) Reports ( based on Stor Proc ) running
against our OLTP database (SQL Server).
Instead of reports running against OLTP database I would like to create
Cubes and create production reports against them.
Is it possible to do that? Are there any client applications which allows to
create these types of reports? We don't need real time information.
Any help is greatly appreciated.

Hi,

There are a lot of third party BI tools for creating
reports that hang off of Analysis Services. My favorite
is Panorama's NovaView. It's simple, intuative, and
allows end users to easily and quickly produce meaningfull
reports.

You can find out more at
http://www.pansw.com/

Paul