Want to call paramterized OTBI report from webservice

Vivek Shokeen

Summary

My wsdl for OTBI calling is working fine but i want to call parameters also from webservice, not able to do so, please suggest .

Content

I have attached the document .

 

I want to pass parameter in webservice to call OTBI report.How to achieve this please 

pmb

Have you tried code such as below to utilise a parameter?

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/&quot; xmlns:v7="urn://oracle.bi.webservices/v7">

    <soapenv:Header/>
    <soapenv:Body>
        <v7:executeXMLQuery>
            <v7:report>
                <v7:reportPath>REPORT LOCATION</v7:reportPath>
            </v7:report>
            <v7:outputFormat>CSV</v7:outputFormat>
            <v7:executionOptions>
                <v7:async>false</v7:async>
                <v7:maxRowsPerPage>200</v7:maxRowsPerPage>
                <v7:refresh>true</v7:refresh>
                <v7:presentationInfo>true</v7:presentationInfo>
            </v7:executionOptions>
            <v7:reportParams>
                <!--Zero or more repetitions:-->
                <v7:filterExpressions>
                    <![CDATA[
<sawx:expr xsi:type="sawx:comparison" op="equal"
            xmlns:saw="com.siebel.analytics.web/report/v1.1"
            xmlns:xsd="http://www.w3.org/2001/XMLSchema&quot;
            xmlVersion="20191211"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance&quot;
xmlns:sawx="com.siebel.analytics.web/expression/v1.1">
<sawx:expr xsi:type="sawx:sqlExpression">"Project"."Project Key"</sawx:expr>
<sawx:expr xsi:type="xsd:string">VALUE TO LOOK FOR</sawx:expr></sawx:expr>]]>
                </v7:filterExpressions>
                  <v7:variables>
               <v7:name>"Project"."Project Key"</v7:name>
               <v7:value></v7:value>
            </v7:variables>

            </v7:reportParams>
            <v7:sessionID>SESSION ID</v7:sessionID>
        </v7:executeXMLQuery>
    </soapenv:Body>
</soapenv:Envelope>