Table of Contents

About

The function is developed with the help of flash and is aimed to paste the definition of the answer in the BI Add-In for MS Office.

Obiee Copy Request Xml To Clipboard Flash

Example of XML Request

<saw:report xmlns:saw="com.siebel.analytics.web/report/v1" xmlns:xsd="http://www.w3.org/2001/XMLSchema" 
xmlVersion="200705140" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
xmlns:sawx="com.siebel.analytics.web/expression/v1">
	<saw:criteria subjectArea="SH">
		<saw:columns>
			<saw:column formula="Customers.&quot;Cust City&quot;" columnID="c0"/>
			<saw:column formula="&quot;Customers&quot;.&quot;Cust Last Name&quot;" columnID="c1"/>
			<saw:column formula="&quot;Customers&quot;.&quot;Cust First Name&quot;" columnID="c2"/>
			<saw:column formula="&quot;Customers&quot;.&quot;Cust Id&quot;" columnID="c3"/>
		</saw:columns>
		<saw:filter>
			<sawx:expr xsi:type="sawx:comparison" op="equal" protected="true">
				<sawx:expr xsi:type="sawx:sqlExpression">"Customers"."Cust City"</sawx:expr>
				<sawx:expr xsi:type="xsd:string">Aachen</sawx:expr>
			</sawx:expr>
		</saw:filter>
	</saw:criteria>
	<saw:views currentView="0">
		<saw:view xsi:type="saw:compoundView" name="compoundView!1" rptViewVers="200510010">
			<saw:cvTable>
				<saw:cvRow>
					<saw:cvCell viewName="titleView!1">
						<saw:displayFormat/>
					</saw:cvCell>
				</saw:cvRow>
				<saw:cvRow>
					<saw:cvCell viewName="tableView!1">
						<saw:displayFormat/>
					</saw:cvCell>
				</saw:cvRow>
			</saw:cvTable>
		</saw:view>
		<saw:view xsi:type="saw:titleView" name="titleView!1" rptViewVers="200510010"/>
		<saw:view xsi:type="saw:tableView" name="tableView!1" rptViewVers="200510010"/>
	</saw:views>
</saw:report>

Browser

Work with :

  • IE7
  • Firefox 3.5.5.