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!

Barticchia

I found the solution by myself after a lot of attempts... I write here in case someone will meet with same problem.

The question was how to insert a prompt parameter in SOAP xml file (in this case).

You have to add a filter and edit with "turn it in sql" adding a variable in this way

ex: "Table"."Field"='@{prompt_impianto}{vuoto}’

In SOAPUI "executeXMLQuery" service, you have to add variable name as showed below:

<v6:variables>

     <v6:name>prompt_impianto</v6:name>

     <v6:value>065128712</v6:value>

</v6:variables>

In that way, report will be filtered

SB

994426

How do we call multiple values for the same Prompt?