Problem filling crosstab from xmla datasource

[setfire]

Dear iReport Experts,

I'm currently trying to fill a crosstab with data that is retrieved from an xmla-mdx datasource (the Foodmart example). I managed to fill the row-axis of the crosstab with the rows retrieved from mondrian and the column-axis of the crosstab with the columns retrieved from mondrian. But the measure (which I select on pages in the mdx) does not seem to be accessible in the report. The cells of the crosstab do all contain null values. The problem occurs with iReport 3.7.1.

Here's the MDX query:

SELECT
  NON EMPTY { [store].[store State].Members  } ON COLUMNS,
  NON EMPTY { [Time].&[2006].children  }       ON ROWS,
  NON EMPTY { [Measures].[Profit]  }           ON PAGES
FROM [sales]

The following fields are defined in the report:

• Store State: Columns[store].[store State]
• Quarter:     Rows[Time].[Quarter]
• Profit:      Pages[Measures].[Profit]
• CellValues:  Data(?,?,0)

The crosstab in the report is defined in the following way:

• The Store State field is put on the columns axis of the crosstab.
• The Quarter field is put on the rows axis of the crosstab.
• The CellValues field is used for the cells of the crosstab

I also tried the following definitions for the CellValues field:

• Data(?,?,?)
• Data(?,?,[Measures].[Profit])

Also with no success. As you can see in the picture attached to this post, the row headings and column headings of the crosstab are working, but not the cell values.

Can anyone please hint me on what I'm doing wrong? Maybe there exists a completely different solution for what I'm trying to achieve? I also attached the jrxml.

Thanks in advance!

Sören

Post Edited by setfire at 03/27/2010 12:27