(Information is Beautiful)

OBIEE Writeback

Finally. An OBIEE writeback XML that works (courtesy Caitlin)

<?xml version="1.0" encoding="utf-8"?>
<WebMessageTables xmlns:sawm="com.siebel.analytics.web/message/v1">
<WebMessageTable lang="en-us" system="writeBack" table="Messages">
<WebMessage name="writeback-test">
<XML>
<!--
EDW_BI_USER.writeback_test
ID NUMBER @1 auto-sequence
MODEL_NAME VARCHAR2(20 BYTE) '@2' set once
MODEL_VERSION VARCHAR2(20 BYTE) '@3' set once
UPDATED_DATE DATE sysdate automatic
STATUS_FLAG VARCHAR2(20 BYTE) '@5' Active, Inactive
A_PERCENTAGE NUMBER @6
A_NUMBER NUMBER @7
A_STRING VARCHAR2(20 BYTE) '@8'
-->
<writeBack connectionPool="EDW Connection Pool">
<insert>INSERT INTO edw_bi_user.writeback_test (MODEL_NAME, MODEL_VERSION, UPDATED_DATE, STATUS_FLAG, A_PERCENTAGE, A_NUMBER, A_STRING) VALUES ('@2','@3', SYSDATE, 'Active', @6, @7,'@8')</insert>
<update>UPDATE edw_bi_user.writeback_test SET MODEL_NAME='@2', MODEL_VERSION='@3', UPDATED_DATE=sysdate, STATUS_FLAG='Active', A_PERCENTAGE=@6, A_NUMBER=@7, A_STRING='@8' WHERE ID=@1</update>
<postUpdate>COMMIT</postUpdate>
</writeBack>
</XML>
</WebMessage>
</WebMessageTable>
</WebMessageTables>
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s