cancel
Showing results for 
Search instead for 
Did you mean: 

Multiple Parameters Oracle Fusion OTBI WebService not Filtering the data

Highlighted
New Contributor

Multiple Parameters Oracle Fusion OTBI WebService not Filtering the data

 

Hi,

 

Could any one advise how to pass parameters for filtering the data through the OTBI Report webService using the SOAPUI.

analytics-ws/saw.dll?SoapImpl=xmlViewService

Though passing the Parameter values for filtering the data, it is gives me all the data without applying the filtering.

 

Praku_0-1600422243042.png

 

Praku_0-1600422063340.png

 

 

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:v6="urn://oracle.bi.webservices/v6">
<soapenv:Header/>
<soapenv:Body>
<v6:executeXMLQuery>
<v6:report>
<v6:reportPath>/shared/Custom/XxMyAnalysis</v6:reportPath>
<v6:reportXml></v6:reportXml>
</v6:report>
<v6:outputFormat></v6:outputFormat>
<v6:executionOptions>
<v6:async></v6:async>
<v6:maxRowsPerPage></v6:maxRowsPerPage>
<v6:refresh></v6:refresh>
<v6:presentationInfo></v6:presentationInfo>
<v6:type></v6:type>
</v6:executionOptions>
<v6:reportParams>
<!--Zero or more repetitions:-->
<v6:filterExpressions></v6:filterExpressions>
<!--Zero or more repetitions:-->
<v6:variables>
<v6:name>Person Gender</v6:name>
<v6:value>Female</v6:value>
</v6:variables>
<!--Zero or more repetitions:-->
<v6:nameValues>
<v6:name>Person Number</v6:name>
<v6:value>10</v6:value>
</v6:nameValues>
<!--Zero or more repetitions:-->
<v6:templateInfos>
<v6:templateForEach></v6:templateForEach>
<v6:templateIterator></v6:templateIterator>
<!--Zero or more repetitions:-->
<v6:instance>
<v6:instanceName></v6:instanceName>
<!--Zero or more repetitions:-->
<v6:nameValues>
<v6:name></v6:name>
<v6:value></v6:value>
</v6:nameValues>
</v6:instance>
</v6:templateInfos>
<!--Optional:-->
<v6:viewName></v6:viewName>
</v6:reportParams>
<v6:sessionID>271rem47rcvrgid37gn9bubgqnsm30hr69inr</v6:sessionID>
</v6:executeXMLQuery>
</soapenv:Body>
</soapenv:Envelope>

 

 

Thanks

Praku

6 REPLIES 6
Highlighted
Community Hero

Re: Multiple Parameters Oracle Fusion OTBI WebService not Filtering the data

Hey @Praku,

Im responding to this cos no one else has yet, so i'll try and help, but im a bit confused.
You state youre passing filter parameters, but its not filtering and youve included some sort of screenshot including some sort of dropdown "filter number" and "filter gender", but i dont know where this filter functionality is. Im using ReadyAPI, not SoapUI so there are obviously gonna be some differences but i dont understand.
Are you saying theres these dropdowns are in SoapUI that enable you to filter the content once the response has been received or do you mean something else?

I can see you have number amd gender tag values but other than that, im not understanding.

Can you clarif what you mean and then perhaps then we can try and sort you out?

Cheers

Rich
if this helped answer the post, could you please mark it as 'solved'? Also if you consider whether the title of your post is relevant? Perhaps if the post is solved, it might make sense to update the Subject header field of the post to something more descriptive? This will help people when searching for problems. Ta
Highlighted
New Contributor

Re: Multiple Parameters Oracle Fusion OTBI WebService not Filtering the data

Hi Rich,

 

Thanks for your response.

Apologize for confusion.

 

To make it simpler the requirement is to automate to run the report using the webservice using the filter parameters.

 

The same OTBI report works fine when it runs from application (UI) and it filters the data based on the parameters.

 

I have two parameters "Person Number" and "Person Gender" for filtering the data.

 

Hope I made it clear this time.

 

Thanks

Highlighted
Community Hero

Re: Multiple Parameters Oracle Fusion OTBI WebService not Filtering the data

Hi @Praku 

 

ah - ok - now I think understand what you mean.  It all depends on what your endpoint supports and how/if you can alter the parameters.

 

This is not REST - this is SOAP - and SOAP doesnt include parameters to filter/tailor your request's response.

 

Obviously I dont know your endpoint and what is supported and what isnt - but considering what I know about SOAP and my previous experience with SOAP projects - the only way I can see you filtering the content is by altering the payload of your request (within the SOAP envelope) to retrieve the specific data you need on your SOAP POST.

 

This isnt really a SoapUI question.  What your endpoint supports and if/how you can filter the data on the response would be defined in the requirements that describe the functionality of your SOAP endpoint.

 

this might not be available via your SOAP - filtering of your data could be performed by whatever Reporting functionality youre using.

 

Essentially you need to check your requirements and this will tell you what you need to know.

 

Sorry i cant help any more

 

ta

 

rich 

if this helped answer the post, could you please mark it as 'solved'? Also if you consider whether the title of your post is relevant? Perhaps if the post is solved, it might make sense to update the Subject header field of the post to something more descriptive? This will help people when searching for problems. Ta
Highlighted
New Contributor

Re: Multiple Parameters Oracle Fusion OTBI WebService not Filtering the data

Hi Richie,

 

Thanks for giving an attempt.

But for me to further proceed I am looking for sample payload.

There is no change in the requirement.

 

 

Highlighted
Community Hero

Re: Multiple Parameters Oracle Fusion OTBI WebService not Filtering the data

@Praku 

 

yes, no - i know there's no change in requirement - you misunderstood me  - thats not what i said.

 

i said to check the requirements to find out how to tailor your payload as this isnt a SoapUI specific question - this relates specifically to your SOAP endpoint.

 

ta

 

rich

if this helped answer the post, could you please mark it as 'solved'? Also if you consider whether the title of your post is relevant? Perhaps if the post is solved, it might make sense to update the Subject header field of the post to something more descriptive? This will help people when searching for problems. Ta
Highlighted
New Contributor

Re: Multiple Parameters Oracle Fusion OTBI WebService not Filtering the data

Hi

 

I am looking for a solution who can provide fix for my issue.

I replied so that this question remains unanswered so some other member can provide solution who come across such issues.

New Here?
Join us and watch the welcome video:
Announcements
Top Kudoed Authors