Webservice executeXMLQuery with executeXMLQuery

Question

Hi, I managed to execute web service executeXMLQuery, but I do not know how to apply a filter expression. Has anyone managed to execute executeXMLQuery web service with Can you please provide the syntax with an example? Thanks, Ark path/name SAWRowsetSchemaAndData true 10 false false 1 ?????????? xxxxxxxxxxxxxxxxxxxxx

User_Z8Y6M · Answer

I've managed to do that. Following the syntax: "Presentation Table"."Filed Name" abcdefg ]]>

Gianni Ceresa · Answer

I was hoping the Java client generated from the WSDL would give me the direct answer, but it doesn't (it even lack a method to set it ).

Then I remembered the doc gives extra hints and not just a structure for this parameter : https://docs.oracle.com/middleware/1221/biee/BIEIT/structures.htm#i1019665

Look at "Table 2-73 How Filter Expressions Are Applied to an Analysis in Oracle BI EE Web Services", there is a method called.

Also have a look at https://oraclebizint.wordpress.com/2007/07/31/customizing-obi-ee-soap-api/  and the comments of July 22, 2008 and the few answers underneath it.

You are executing an Analysis which is just a bunch of XML, the filters also needs to be XML. So you need to get the right syntax using the OBIEE XML structure for it.

That's why I always stay with "executeSQLQuery" as it takes a logical SQL directly without bothering with XML (so a filter in the query is just in the WHERE clause).

User_Z8Y6M · Answer

Hi Gianni, Thanks for the comment. If I want to pool data from obiee analysis from an external system, the executeXMLQuery is very convenient, because I need to apply to the report path/name only and don't need to understand how the analysis was created. I managed to do that when I do not need to pass parameters. But, if I need to apply to the same analysis each time with a different filter, for instance, first time "Table"."Field" = ' a', and the second time "Table"."Field" = 'a' , I do not know the syntax of ?????????? Thanks, Ark