OBIEE SOAP Implementation - Minor Issue

994426

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:

<v6:variables>
<v6:name>PRODUCT</v6:name>
<v6:value>ABC</v6:value>
</v6:variables>

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:

<v6:variables>
<v6:name>PRODUCT</v6:name>
<v6:value>ABC</v6:value>

<v6:value>XYZ</v6:value>
</v6:variables>

<v6:variables>
<v6:name>PRODUCT</v6:name>
<v6:value>ABC,XYZ</v6:value>

</v6:variables>

<v6:variables>
<v6:name>PRODUCT</v6:name>
<v6:value>ABC;XYZ</v6:value>

</v6:variables>

None is working. Can you please help me? How to get data for both Prompt values?

Gianni Ceresa

994426 wrote:None is working. 

What does it mean? You get only data for ABC? You don't get anything back? You have an error?

If you don't have an error did you check what OBIEE does when receiving your request with the various formats? If you look at the LSQL you can maybe have a hint on what to change to make it work as expected.

994426

Thank you for your response. Here are the results:

Test 1:

<v6:variables>

<v6:name>PRODUCT</v6:name>

<v6:value>ABC</v6:value>

<v6:value>XYZ</v6:value>

</v6:variables>

Output - ABC

Test 2:

<v6:variables>

<v6:name>PRODUCT</v6:name>

<v6:value>ABC,XYZ</v6:value>

</v6:variables>

Output - Error

Test 3:

<v6:variables>

<v6:name>PRODUCT</v6:name>

<v6:value>ABC;XYZ</v6:value>

</v6:variables>

Output - Error

Test 4:

<v6:variables>

<v6:name>PRODUCT</v6:name>

<v6:value>ABC</v6:value>

</v6:variables>

<v6:variables>

<v6:name>PRODUCT</v6:name>

<v6:value>XYZ</v6:value>

</v6:variables>

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?

Gianni Ceresa

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

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