iReport with Mondrian OLAP connection

[sergiomaky]

hello:

 

i have a report with mondrian connection, this connection is well built (i have made the test and it returns "connection test succesfully")

 

when i run the report, ireport shows the next error:

 

ErrorÂfillingÂprint...

OpeningÂMondrianÂconnection ClosingÂMondrianÂconnection net.sf.jasperreports.engine.JRRuntimeException:ÂIncorrectÂdataÂmapping:ÂtheÂnumberÂofÂpositionsÂdoesn'tÂmatchÂtheÂnumberÂofÂaxes. ÂÂÂÂatÂnet.sf.jasperreports.olap.JRMondrianDataSource$DataFieldMatcher.<init>(JRMondrianDataSource.java:477) ÂÂÂÂatÂnet.sf.jasperreports.olap.JRMondrianDataSource.createFieldMatcher(JRMondrianDataSource.java:287) ÂÂÂÂatÂnet.sf.jasperreports.olap.JRMondrianDataSource.init(JRMondrianDataSource.java:255) ÂÂÂÂatÂnet.sf.jasperreports.olap.JRMondrianDataSource.<init>(JRMondrianDataSource.java:115) ÂÂÂÂatÂnet.sf.jasperreports.olap.JRMondrianQueryExecuter.createDatasource(JRMondrianQueryExecuter.java:84) ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:662) ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRFillDataset.setDatasource(JRFillDataset.java:606) ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRFillDataset.setParameterValues(JRFillDataset.java:595) ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:879) ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:708) ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:123) ÂÂÂÂatÂnet.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:420) ÂÂÂÂatÂnet.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:256) ÂÂÂÂatÂit.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:829) ÂÂÂÂatÂjava.lang.Thread.run(UnknownÂSource)

 

can anybody help me, please???

[lucianc]

This error is caused by field mappings inconsistent with the MDX query: a data/cell mapping specifies axis positions but the number of positions doesn't match the number of axes of the query result cube.

 

HTH,

Lucian

[vgarcia]

Hi Lucianc,

 

If i have the mdx:

 

select {[Measures].[unit Sales]} on columns,

{([Product].[All Products] ) } on rows

from Sales

 

How should be the expression of the field?

 

Thanks in advance.

[lucianc]

You can use the following mapping for a data field:

Data([Measures].[unit Sales],?)

 

Or, since you have only one measure on the column axis, you can also simply use Data as the field mapping.

 

HTH,

Lucian

[vgarcia]

Thanks Lucian.

 

I have one more question. If i have the previous mdx:

 

select {[Measures].[unit Sales]} on columns,

 

{([Product].[All Products] ) } on rows

 

from Sales

 

 

I want to show all data, and the values of the dimensions, etc. I want to say that i want to show all data that we would see in the cube.

 

What fields i need to create?

[lucianc]

You can't use this query to display "all the data in the cube", since the query result cube consists of a single element. You would need a query like

Code:

select {[Measures].[unit Sales]} on columns,
[Product].members on rows
from Sales

 

Using this query, you can map fields to dimension values, e.g. Rows[Product][Product Category].

 

You can check the "mondrian" sample in the JasperReports distribution, it contains a couple of MDX reports.

 

HTH,

Lucian