Drillthrough in a report

[eisenfreundo]

Hi,

I'm using JasperServerPro 3.7 and iReportPro 3.7. Further I use a Mondrian-connection and mdx as query-language.

How can I perform a drillthrough in a report? I tried to do some crossjoins with the lowest levels in my dimensions but if there are two products in the same level, their values are aggregated.
I know now, that I need a drillthrough in my MDX-query. No matter what I do, I can't get the correct syntax.
In the analysis-view I click on a measure and can see each row of my selected data. I need to do the same in a report.

I tried many querys from different pages, but I can't get it working.

DRILLTHROUGH
SELECT {ZeitOhneQ.[2009].[Februar]} ON 0
FROM [Auftraege]
WHERE (
Gruppe.[...],
Auftragsart.[Wiedereinsatz],
Auftragsstatus.[neu])
RETURN
[Measures].[Anzahl],
[Measures].[Genehmigungsbetrag]

The query-parser always tell me that there is an error in line 1.
Do I have to change a setting or something?

Can you send me a working query which performs a drillthrough in a report using Mondrian-connection?

Cheers, Alex

EDIT

I've read http://sourceforge.net/projects/olap4j/forums/forum/577988/topic/1937569 and it seems that it is not possible with mondrian. Can somebody help me to convert my query to XMLA?

Post Edited by eisenfreundo at 11/05/2010 16:29