Configure Write Back In OBIEE 11g

  Write back is a feature that allows users to type values into the dashboard and then copy them back to the underlying source database.

Follow the steps to enable it in your environment......

Step1: Enable Writeback at system level.

Add the following line between the tags <WebConfig> and </WebConfig> in the instanceconfig.xml located under $INSTANCE_HOME/config/OracleBIPresentationServicesComponent/coreapplication_obips1:

<LightWriteback>true</LightWriteback>

Step2: Create Template for write back.

Create your own xml for your report and save the file in below location with any name with .xml format.
Path: $INSTANCE_HOME\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\analyticsRes\customMessages

Sample File :  emp.xml

<?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="SetWriteBackValue">
         <XML>
            <writeBack connectionPool="OBIEEDB_POOL">
              <update>UPDATE SCOTT.EMP SET SAL=@2 WHERE ENAME='@1'</update>
    </writeBack>
         </XML>
      </WebMessage>
   </WebMessageTable>
</WebMessageTables>


Note: OBIEE 11.1.1.5 and above versions already has a template SQL for write back under above location with name writebacktemplate.xml. 


Step 3 : Give the permissions
check and give the write back permissions to the user in Analytics->Administration> Manage Privilege as shown below:

Step 4:  Enable Writable option at logical column level.

Step 5 : Allow Execute Direct Database Requests to the user.

Step 6 : Bounce your OBIPS and OBIS to reflect your changes.

Step 7 :  Now create report with ENAME, SAL columns and go to SAL column properties --> Write Back tab --> and select Enable Write Back check box.

Step 8 :  Finally edit table view properties and check the tab 'Enable write back'.In the template name field,make sure that you have provided the SetWriteBackValue  as documented in WebMessage Tag in emp.xml file

Step 9 :  Then click Update , modify values and click Apply  button. That set, updated values should have gone to database , if you have done above steps correctly :).

Other Related Posts : 
Write-Back Limitations in OBIEE 11G
OBIEE 11g: Writeback Done Button Does Not Refresh Data Displayed


-Asifkhan P.