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
