I’ve added only dimension to my Query as a Web Service and the option
Duplicate Rows Aggregation is greyed out but I can see a tick/marker (so it is activated)
Retrieve Duplicate Rows is not ticked
When I publish the QaaWS with the Software “Query as a Web Service Designer”
then I get a Preview and I can see in my Oracle Software via Database/Session Monitor the SQL that has been executed
it has been executed as SELECT DISTINCT … FROM …
so the option Duplicate Rows Aggregation works inside of the client software
BUT: when we now call the published and deployed Qaaws via SOAP
(access of the generated WSDL) then I can see via my Oracle Client that the SQL has been executed as
SELECT … FROM … (i.e. without DISTINCT)
so the option Duplicate Rows Aggregation seems not to work
this is our SOAP call:
http://[SERVER-URL]/dswsbobje/qaawsservices/queryasaservice HTTP/1.1
Accept-Encoding: gzip,deflate
Content-Type: text/xml;charset=UTF-8
SOAPAction: “[WEBSERVICENAME]/runQueryAsAService”
Content-Length: 744
Host: [SERVER URL]
Connection: Keep-Alive
User-Agent: Apache-HttpClient/4.1.1 (java 1.5)
Software VErsion is
14.05.2005
Build 915
[I implemented meanwhile a workaround: I’ve added a MEASURE to my Qaaws, then the SAP BO QaaWS executed the statement as SELECT dim 1, dim 2, measure 1 FROM … GROUP BY dim1, dim2 => so at the end I can get via this workaround my distinct result…but would be nice to get info from you, if the above option does’nt work or if it gives a possibility to activate this option so it will work…Thank You]
boximaster (BOB member since 2008-05-26)