Does Jasper support SQL Server Analysis Services ?

[longbeach]

Hi,
does anyone know if JasperReports can connect to a multi dimensional database ?
Our database is SQL Server 2008 Analysis Services and we need to know if there is a connector
available to connect to it to generate reports.

I am talking about SQL Server 2008 Analysis Services, not SQL Server 2005.

Also, which solution is better ?
JasperReports BI Suite ? JasperReports Intelligence ?

Another of our requirements is the ability to use a Web interface that allows the user to select
the data he wants to show in the reports.

Thanks for your feedback.

Post Edited by longbeach at 02/05/2010 16:29

[gautier]

You can use MDX queries on the top of XML-A Datasources in JasperReports.

 

About your other requirements i suggest you to have a look at the pro edition.

Here is a demo of this features :

http://www.jaspersoft.com/user/register?destination=node%2F603

 

Hope this helps,

Guillaume