glen Posted April 1, 2009 Share Posted April 1, 2009 I am trying to get an MDX or XMLA report to work in the new iReport Netbeans 3.5.0.I am running into a catch-22If I set the active connection as an MDX connection then the query designer will not open and comes up with a message saying that the active connection has to be an XMLA connectionIf I set the active connection as an XMLA connection and then go into the query designer I can design a query but cannot map the fields so the report fields all show up as 'null'Anyone come across this - and got a solution ? Ultimately what I am trying to achieve is to build the report in iReport and the upload it to JasperServer. Post Edited by Glen Bremner-Stokes at 04/02/09 09:18Post Edited by Glen Bremner-Stokes at 04/02/09 09:46 Link to comment Share on other sites More sharing options...
Giulio Toffoli Posted April 1, 2009 Share Posted April 1, 2009 This is what you get today. Tha mapping tool is based on the Mondrian file descriptor available with a pure OLAP Mondrian connection. The MDX query designer works only with XMLA connections.A bad workaround is design the query using an XMLA connection and then switch to the olap connection to map the fields.Giulio Link to comment Share on other sites More sharing options...
glen Posted April 1, 2009 Author Share Posted April 1, 2009 Giulio, I really appreciate you taking the time to respond. I had tried that as a workaround actually. I switched the active connection to an OLAP connection and also changed the Query Language to MDX. But I found that the mapping tree did not populate at all. That frame just stayed blank. Is there a trick to getting the tree to display ? Link to comment Share on other sites More sharing options...
glen Posted April 2, 2009 Author Share Posted April 2, 2009 This looks like a bug to me. My very simple MDX query included below. Unless there is something wrong with the query. Test case is very simple. On iReport 3.5.0:1. create an OLAP data connection2. in the report query designer set the language to MDX3. type in any appropriate MDX query4. The tree mapping tool in the right hand pane does not load anything I tried to see whether I could log this on Tracker but I see no way to do that. If someone can tell me how then I am happy to raise this issue. Code: Post Edited by Glen Bremner-Stokes at 04/02/09 10:22Post Edited by Glen Bremner-Stokes at 04/02/09 10:26 Link to comment Share on other sites More sharing options...
svbridget Posted April 3, 2009 Share Posted April 3, 2009 I see the same problem with trying to execute an MDX query in 3.5.0. It seems that maybe 3.5.0 does not support MDX...? Link to comment Share on other sites More sharing options...
glen Posted April 3, 2009 Author Share Posted April 3, 2009 Yeah - any idea how to get a developer to take a look for us ? Link to comment Share on other sites More sharing options...
glen Posted April 15, 2009 Author Share Posted April 15, 2009 Issue 2765255 raised on Tracker Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now