Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Obiee 11g how to pass prompt parameters in soapUI xml

BarticchiaNov 23 2016 — edited Mar 22 2017

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>

<v6:filterExpressions></v6:filterExpressions>

<v6:variables>

<v6:name></v6:name>

<v6:value></v6:value>

</v6:variables>

<v6:nameValues>

<v6:name></v6:name>

<v6:value></v6:value>

</v6:nameValues>

<v6:templateInfos>

<v6:templateForEach></v6:templateForEach>

<v6:templateIterator></v6:templateIterator>

<v6:instance>

<v6:instanceName></v6:instanceName>

<v6:nameValues>

<v6:name></v6:name>

<v6:value></v6:value>

</v6:nameValues>

</v6:instance>

</v6:templateInfos>

<v6:viewName></v6:viewName>

</v6:reportParams>

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

</v6:executeXMLQuery>

</soapenv:Body>

</soapenv:Envelope>

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

response 2

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

<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>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

</Row>

<Row>

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

<v6:filterExpressions></v6:filterExpressions>

<v6:variables>

<v6:name></v6:name>

<v6:value></v6:value>

</v6:variables>

<v6:nameValues>

<v6:name></v6:name>

<v6:value></v6:value>

</v6:nameValues>

<v6:templateInfos>

<v6:templateForEach></v6:templateForEach>

<v6:templateIterator></v6:templateIterator>

<v6:instance>

<v6:instanceName></v6:instanceName>

<v6:nameValues>

<v6:name></v6:name>

<v6:value></v6:value>

</v6:nameValues>

</v6:instance>

</v6:templateInfos>

<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!

This post has been answered by Barticchia on Jan 16 2017

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 19 2017

Added on Nov 23 2016

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

2 comments

1,112 views