error data preview with mdx query and XMLA Data Adapter
Posted on December 3, 2013 at 11:51pm
I have the following error during the data preview with a mdx query connected to a XMLA Data Adatper :
net.sf.jasperreports.engine.JRRuntimeException: XML/A fault: XMLA MDX parse failed; Actor: Mondrian; Code: SOAP-ENV:Client.00HSBD01;
The mdx query is correct, and run into the ad hoc view, but when I put it to the JasperStudio, I have the "read fields" disabled and the data preview with the error described.
Do you have any suggestion, please ?
Posted on December 4, 2013 at 8:05am
can you please give more details on this? The read fields is disabled since there is not automatic fields retrieval support and the MDX query designer is on the TODO list of new features to implement. You need to add fields manually for now, did you?
Posted on December 5, 2013 at 12:34am
thanks for your reply, I understood that the read fields is disabled since there is not automatic retrieval (even is not so intuitive), and so I added manually my fields, now what I didn't understand is if I'm wrong the syntax in fields name/field type/description, because the exception don't give me a clear information.
Posted on December 5, 2013 at 1:06am
are you able to attach information about the query and the fields you have specified? Also the exception you get if possible.
It will be nice to have the JRXML so we can try an debug.
Posted on December 5, 2013 at 6:30am
I tried to edit my XMLA Data Adapter connection to point the SugarCRM Schema, one of the example of JasperServer 5.5, to test the "preview data" functionality in JasperStudio, and the problem persist, but now I think it is more easy to replicate the problem. I attached you my mdx query, fields definition and finally the error.
Posted on December 12, 2013 at 12:30am
Does anyone have suggestions to help me?