How to display result of MDX query ?

[szymic1]

Hi,

I've define and connected to Mondrian OALP datasource. I've define very simple MDX query

select {[Measures].[PaymentValue]} ON COLUMNS,
  NON EMPTY {[GroupPaymentType.AllGroupPaymentTypes].[AllGroupPaymentTypes]} ON ROWS
from [Payment]

 

Using 'Report Query' I've created one field PaymentValue -  Data([Measures].[PaymentValue]) and I've tried to use this field on report. After clicking on preview I've got:

Error filling print... Incorrect data mapping: the number of positions doesn't match the number of axes.
net.sf.jasperreports.engine.JRRuntimeException: Incorrect data mapping: the number of positions doesn't match the number of axes.      at net.sf.jasperreports.olap.JROlapDataSource$DataFieldMatcher.<init>(JROlapDataSource.java:473)      at net.sf.jasperreports.olap.JROlapDataSource.createFieldMatcher(JROlapDataSource.java:281)

To be honest I do not understand what is wrong. By the way where I can find report examples with OLAP datasouce?

Michal Szymanski

http://blog.szymanskich.net