JasperReport xmla report problems

[mszalay]

Hi

 

i try to run a report using a xmla datasource. The report was designed by iReport and works there.

 

If I want to execute the report programmatically, I got the following problems:

 

1) I had to change the <queryString language="mdx"> from xmla-mdx to mdx

 

2) the report does not work (jasperreport cannot map my fields):

 

net.sf.jasperreports.engine.JRRuntimeException: Invalid field mapping "[Date].[Date_Year].[All]".

at net.sf.jasperreports.olap.JROlapDataSource.init(JROlapDataSource.java:248)

at net.sf.jasperreports.olap.JROlapDataSource.<init>(JROlapDataSource.java:113)

at net.sf.jasperreports.olap.xmla.JRXmlaQueryExecuter.createDatasource(JRXmlaQueryExecuter.java:122)

 

..is the example for a field with description Date].[Date_Year].[All].

 

any hints how to solve this problems?

 

thanks a lot

[mszalay]

I managed to solve the first problem by putting the following line before compiling the report:

 

JRProperties.setProperty("net.sf.jasperreports.query.executer.factory.xmla-mdx", "net.sf.jasperreports.olap.xmla.JRXmlaQueryExecuterFactory");

 

 

Additional information to the second problem: the parser gets a

"line 1:1: unexpected token:" for each field in the report.

 

Anyone an idea?

 

Thanks.

[lucianc]

Which JR version are you using? Is this the same in both environments (iReport and the one where the report does not work)?

 

How do the field mappings look like?

 

Regards,

Lucian

[mszalay]

I got the solution. The property has to look like this:

 

JRProperties.setProperty("net.sf.jasperreports.query.executer.factory.xmla-mdx", "net.sf.jasperreports.engine.query.JRXmlaQueryExecuterFactory");

 

The confusing thing is: this class is not delivered with jasperreports, but with ireport (jar file: cincom-jr-xmla.jar).

 

I'm using jasperreports 1.3.3.

 

Now it works.

 

Regards Michael

[Yuna]

I see, you got XMLA connection with iReport? please, could you tell me, what did you write in the field "URL of XMLA Server"? I have to connect to SQL Server Analysis Service. And I can't find: HOW? Do you know something about this problem?

[mszalay]

Hi Yuna

 

in the URL field, you have to type the url of your analysis server.

 

If your server is at 192.168.0.1, then try

 

http://192.168.0.1/MSAS/msmdpump.dll

 

Regards Michael

[Yuna]

Thank you!

I tried, but "Error:Connection refused:connect". May be I must set up any settings on my server? or may be use Tomcat? any settings there?

[Yuna]

Hi, mszalay!

I found how to configure http access to MSAS, but connection failed with response code 405. Any solutions of thi problem? Please!:)

[Yuna]

hi again!:)

my connection almost works. Datasource appeared. But there isn't "Catalog" and "Cube". On my server they are, I deployed my cude and processed. Can somebody tell me, why they didn't appear after my click "Get metadata"?