OBIEE SOAP Implementation - Minor Issue

Question

Hi, I am writing a code in executeXMLQuery in SOAP to call Presentation Variable created in my OBIEE report. I need to pass more than one value under Variable. This is what the code looks like: PRODUCT ABC When I execute the code, I get details where Product = ABC. Now, I want to get details where Product is either ABC or XYZ like Product IN (ABC,XYZ). I tried all of these: PRODUCT ABC XYZ PRODUCT ABC,XYZ PRODUCT ABC;XYZ None is working. Can you please help me? How to get data for both Prompt values?

994426 · Answer

ok, it could very well be the case that OBIEE WSDL/v6 doesn't support passing multiple Prompt values via SOAP code/methods.

I checked the queries at back-end but there isn't an easy way to decipher what we can do from SOAP by looking at OBIEE queries. This is more on the SOAP side - how multiple values can be applied in SOAP code.

If anyone here has success in implementing this, it will be very helpful to know

Gianni Ceresa · Answer

Yes, the query must be logged like any other query, that's why you can maybe find some hints there looking at what the server generate to try to find out the format.

994426 · Answer

Thank you for your response. Here are the results: Test 1: PRODUCT ABC XYZ Output - ABC Test 2: PRODUCT ABC,XYZ Output - Error Test 3: PRODUCT ABC;XYZ Output - Error Test 4: PRODUCT ABC PRODUCT XYZ Output - XYZ My desired output is ABC, XYZ My assumption is the queries generated via SOAP should be tracked in nqquery.log. May be I can check there?