Forum Discussion

Praku's avatar
Praku
New Contributor
5 years ago

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.

 

 

 

 

<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

  • richie's avatar
    richie
    Community Hero
    5 years ago
    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
    • Praku's avatar
      Praku
      New Contributor
      5 years ago

      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

      • richie's avatar
        richie
        Community Hero
        5 years ago

        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