XMLA-MDX reports on Jasper Server

[sure919]

Hello,

 

I am getting errors while trying to deplpoy my report (with query language as XMLA-MDX which runs fine on Jasper Studio) on Jasper Server. the error message is

No query executer factory class registered for xmla-mdx queries. Create a propery named net.sf.jasperreports.query.executer.factory.xmla-mdx

What changes I have to make to deploy the xmla-mdx based reports.

Looking for the kindest reply,

thanks,

Sure

 

[lucianc]

What you need to do is to is to edit $TOMCAT/webapps/jasperserver/WEB-INF/classes/jasperreports.properties and add the following line:

net.sf.jasperreports.query.executer.factory.xmla-mdx=net.sf.jasperreports.olap.xmla.JRXmlaQueryExecuterFactory

HTH,

Lucian

[sure919]

Thanks Lucian,

I tried setting the property

net.sf.jasperreports.query.executer.factory.xmla-mdx=com.cincom.jasperreports.JRXmlaQueryExecuterFactory

The reports doesnt throw error upon execution but doesnt show result either. It displayed the following WARN Messages on Tomcat console

14:43:30,953  WARN JRXmlaQueryExecuter,http-8080-Processor22:62 - The supplied url is null.
14:43:30,969  WARN JRXmlaQueryExecuter,http-8080-Processor22:71 - The supplied datasource is null
14:43:30,969  WARN JRXmlaQueryExecuter,http-8080-Processor22:80 - The supplied catalog is null.

 

indicating that the XMLA  connection parameters are not being passed.

Any help is great!!

Thanks,
sure

 

[sure919]

Thanks Lucian,

I tried setting the property

net.sf.jasperreports.query.executer.factory.xmla-mdx=com.cincom.jasperreports.JRXmlaQueryExecuterFactory

The reports doesnt throw error upon execution but doesnt show result either. It displayed the following WARN Messages on Tomcat console

14:43:30,953  WARN JRXmlaQueryExecuter,http-8080-Processor22:62 - The supplied url is null.
14:43:30,969  WARN JRXmlaQueryExecuter,http-8080-Processor22:71 - The supplied datasource is null
14:43:30,969  WARN JRXmlaQueryExecuter,http-8080-Processor22:80 - The supplied catalog is null.

 

indicating that the XMLA  connection parameters are not being passed.

Any help is great!!

Thanks,
sure

 

[lucianc]

Are you using a XMLA connection as report data source in JasperServer?

Regards,

Lucian

[sure919]

Hi Lucian

Thanks for replying

I am not sure if I unerstand your question correctly; While in iReport i defined the connection to my xmla server and got the report working and in JS defined the XMLA connection and referenced it while adding the report unit.

hope this helps you to understand what i am doing.

Thanks,

Sure

[sure919]

Hi Lucian

Thanks for replying

I am not sure if I unerstand your question correctly; While in iReport i defined the connection to my xmla server and got the report working and in JS defined the XMLA connection and referenced it while adding the report unit.

hope this helps you to understand what i am doing.

Thanks,

Sure

[sure919]

Hi Lucian

Thanks for replying

I am not sure if I unerstand your question correctly; While in iReport i defined the connection to my xmla server and got the report working and in JS defined the XMLA connection and referenced it while adding the report unit.

hope this helps you to understand what i am doing.

Thanks,

Sure

[lucianc]

What JasperServer version are you using?

The JasperServer sample data includes a report defined on a XML/A data source (at /analysis/reports/FoodmartSalesXmlaReport).  Do you have the sample data loaded into JasperServer?  If so, can you try the sample XML/A report and see whether it works?

Regards,

Lucian

[sure919]

Dear Lucian,

That report is working but has the query language as "mdx" and all my reports have query language as "xmla-mdx".

is there any work around for deploying "xmla-mdx" based reports?

Thanks,
Sure

[sure919]

Dear Lucian,

I have my Dashboards working in Jasper Studio (when using xmla-mdx) is there any eary way to deploy them on Jasper Server (i am using 2.0.1),

As an alternative i also able to deploy reports with modifications (using mdx as query language) on JS but have issues when I deploy the Dashboard. the issue is that the sub-reports are not getting displayed.

Any help is highly valuable for me.

Thanks,
Sure

[lucianc]

That report is working but has the query language as "mdx" and all my reports have query language as "xmla-mdx". is there any work around for deploying "xmla-mdx" based reports?

Did you set the net.sf.jasperreports.query.executer.factory.xmla-mdx property?

If you change the sample's report query language, does it work?

[lucianc]

I have my Dashboards working in Jasper Studio (when using xmla-mdx) is there any eary way to deploy them on Jasper Server (i am using 2.0.1), As an alternative i also able to deploy reports with modifications (using mdx as query language) on JS but have issues when I deploy the Dashboard. the issue is that the sub-reports are not getting displayed.

I assume that a dashboard is a (master) report that includes several subreports.  When you deploy it to JasperServer, do you use a XMLA connection as dashboard report data source?  If so, do you pass the master connection parameters to the subreports?

Regards,

Lucian

[sure919]

I'd set the property and copied the cincom-jr-xmla.jar and rex.jar ; but then the report never shows the result added to that i see warn messages on the tomcat console saying URL, Datasource and catalog are null....

[lucianc]

I don't know what cincom-jr-xmla.jar is.  Aren't you using the built-in JasperReports XML/A query executer?

Regards,

Lucian 

[biaggi]

You need to copy the cincom and rex jars from ireport/lib to WEB-APP/lib and create a spring bean  as data source for the report :) that bean will give the connection information to the report, but you must set the parameters as I explain in this post

http://www.jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=42893

 

else youll keep getting the messages URL is null, catalog is null ...

 

Thats works for me :)