2 Replies Latest reply on Mar 22, 2017 8:04 PM by 994426

    Obiee 11g how to pass prompt parameters in soapUI xml

    Barticchia

      Hi to everyone,

      for the first time i have to solve a new request using soapUI.

      i was looking around different forums and i understood how to set a new SOAP project, connect my obiee server on it and i saw all the webservices available (first step).

      what i think i need are these 3 WS:

       

       

      - SAWSessionService->Logon

      - XmlViewService->executeXMLQuery

      - SAWSessionService->Logoff

       

      This is an example and it works fine.

       

      --------------------------------

      1 - log-on

      --------------------------------

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

         <soapenv:Header/>

         <soapenv:Body>

            <v6:logon>

               <v6:name>*****</v6:name>

               <v6:password>*****</v6:password>

            </v6:logon>

         </soapenv:Body>

      </soapenv:Envelope>

       

      ---------------------

      response 1

      ---------------------

      <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:sawsoap="urn://oracle.bi.webservices/v6">

         <soap:Body>

            <sawsoap:logonResult>

               <sawsoap:sessionID xsi:type="xsd:string">g26v2sc3pqbo0hf8apa3ool3vmftdeljnsacvat94n153dp8</sawsoap:sessionID>

            </sawsoap:logonResult>

         </soap:Body>

      </soap:Envelope>

       

      ---------------------

      2 - call analisi BI

      ---------------------

      <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/REPORT IT/TEST_WSDL</v6:reportPath>

                  <v6:reportXml></v6:reportXml>

               </v6:report>

               <v6:outputFormat>XML</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></v6:name>

                     <v6:value></v6:value>

                  </v6:variables>

                  <!--Zero or more repetitions:-->

                  <v6:nameValues>

                     <v6:name></v6:name>

                     <v6:value></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>g26v2sc3pqbo0hf8apa3ool3vmftdeljnsacvat94n153dp8</v6:sessionID>

            </v6:executeXMLQuery>

         </soapenv:Body>

      </soapenv:Envelope>

       

      ---------------------

      response 2

      ---------------------

      <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:sawsoap="urn://oracle.bi.webservices/v6">

         <soap:Body>

            <sawsoap:executeXMLQueryResult>

               <sawsoap:return xsi:type="sawsoap:QueryResults">

                  <sawsoap:rowset xsi:type="xsd:string"><![CDATA[<rowset xmlns="urn:schemas-microsoft-com:xml-analysis:rowset">

          <Row>

              <Column0>ANNO 2008</Column0>

          </Row>

          <Row>

              <Column0>ANNO 2009</Column0>

          </Row>

          <Row>

              <Column0>ANNO 2010</Column0>

          </Row>

          <Row>

              <Column0>ANNO 2011</Column0>

          </Row>

          <Row>

              <Column0>ANNO 2012</Column0>

          </Row>

          <Row>

              <Column0>ANNO 2013</Column0>

          </Row>

          <Row>

              <Column0>ANNO 2014</Column0>

          </Row>

          <Row>

              <Column0>ANNO 2015</Column0>

          </Row>

          <Row>

              <Column0>ANNO 2016</Column0>

          </Row>

          <Row>

              <Column0>ANNO 2017</Column0>

          </Row>

          <Row>

              <Column0>ANNO 2018</Column0>

          </Row>

      </rowset>]]></sawsoap:rowset>

                  <sawsoap:queryID xsi:type="xsd:string">RSXS2_1</sawsoap:queryID>

                  <sawsoap:finished xsi:type="xsd:boolean">true</sawsoap:finished>

               </sawsoap:return>

            </sawsoap:executeXMLQueryResult>

         </soap:Body>

      </soap:Envelope>

       

      --------------------------------

      3 - log-off

      --------------------------------

       

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

         <soapenv:Header/>

         <soapenv:Body>

            <v6:logoff>

               <v6:sessionID>g26v2sc3pqbo0hf8apa3ool3vmftdeljnsacvat94n153dp8</v6:sessionID>

            </v6:logoff>

         </soapenv:Body>

      </soapenv:Envelope>

       

      ---------------------

      response 3

      ---------------------

      <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:sawsoap="urn://oracle.bi.webservices/v6">

         <soap:Body>

            <sawsoap:logoffResult/>

         </soap:Body>

      </soap:Envelope>

       

       

      The analysis created on obi, is just one field and i added the same field as prompt.

      the question is:

      how and where i have to insert this parameter on xml file?

      in this section?

       

      <v6:reportParams>

                  <!--Zero or more repetitions:-->

                  <v6:filterExpressions></v6:filterExpressions>

                  <!--Zero or more repetitions:-->

                  <v6:variables>

                     <v6:name></v6:name>

                     <v6:value></v6:value>

                  </v6:variables>

                  <!--Zero or more repetitions:-->

                  <v6:nameValues>

                     <v6:name></v6:name>

                     <v6:value></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>

       

       

      where exactly?

      i don't know if this questions and what i want to do is correct; but i'd like to know if is possible retrieve a result using a prompt filter inside the analysis.

       

      Many thanks to all of you!