XMLA Drill Through bug
Brought to you by:
avix
The xmla drill through does not work for me because of
several problems :
1/ In the file XMLA_SOAP.java when call
envelope.createName("Command","","") my soap
implentation build this :
<Command xmlns="">
And mondrian return an error if this field is present
and null.
The solutions are :
- Remove xmlns properties (how can we do that ?).
- or put something in
I resolve it with the second solution ->
Name nCom = envelope.createName("Command","", XMLA_URI);
2/ When a filter is use on a dimension, the slicer
doesn't print it. Also in the navigator we can't see
the filter set. This is working fine with a mondrinaQuery.
In the drill through table all rows are return and the
filter is ignored.
Logged In: YES
user_id=1640522
Originator: NO
The second point is solved in the Mondrian project (8207).
Thanks jhyde !
Logged In: YES
user_id=735048
Originator: NO
Hi, here is a patch to this bug.
*** XMLA_SOAP.java
--- XMLA_SOAP.java
***************
*** 1055,1063 ****
// <Command>
// <Statement>select [Measures].members on Columns from Sales</Statement>
// </Command>
! Name nCom = envelope.createName("Command");
SOAPElement eCommand = eEx.addChildElement(nCom);
! Name nSta = envelope.createName("Statement");
SOAPElement eStatement = eCommand.addChildElement(nSta);
eStatement.addTextNode(query);
--- 1055,1063 ----
// <Command>
// <Statement>select [Measures].members on Columns from Sales</Statement>
// </Command>
! Name nCom = envelope.createName("Command", "", XMLA_URI);
SOAPElement eCommand = eEx.addChildElement(nCom);
! Name nSta = envelope.createName("Statement", "", XMLA_URI);
SOAPElement eStatement = eCommand.addChildElement(nSta);
eStatement.addTextNode(query);