This content has been marked as final. Show 1 reply
I understand you were using XmlViewService.executeXmlQuery() . I am using the same feature, but it always returns 0 rows, even the analysis returns 30 rows when executing on OBIEE.
Could you please suggest a solution. Below is the code i have. I have even tried with maxRowsPerPage, but didn't make any difference.
I am using OBIEE 126.96.36.199.5
XmlViewServiceSoap xmlViewServiceSoap = xmlViewService.getXmlViewServiceSoap();
ReportRef rRef = new ReportRef();
ReportParams rParams = new ReportParams();
XMLQueryExecutionOptions xqeo = new XMLQueryExecutionOptions();
QueryResults qr = xmlViewServiceSoap.executeXMLQuery(rRef, XMLQueryOutputFormat.SAW_ROWSET_SCHEMA_AND_DATA, xqeo, rParams, sessionID);
String result = qr.getRowset();
Edited by: Deep00 on 21-Mar-2013 22:31