OBIEE Online Training

Tuesday, December 21, 2010

Write Back

Write Back
1)      Go to Repository à Physical Layerà table (which table u r going to give write back option) please uncheck cacheable option and save the changes.

2)      Go to Presentation layer -à Manage PrivilegeàGo to scroll down windows-à add Users/Administrator (who are all needs write back option) as mange write Back add Administrator. Finally click finish.

3)      Add XML File to this path  C:\OracleBI\web\msgdb\customMessages\WriteBack.xml  and

C:\OracleBIData\web\msgdb\WriteBack .xml   path.
File Name: WriteBack.xml
<?xml version="1.0" encoding="utf-8" ?>
<WebMessageTables xmlns:sawm="">
<WebMessageTable lang="en-us" system="WriteBack" table="Messages">
<WebMessage name="WriteBack">
<writeBack connectionPool="Connection Pool">
<update>UPDATE db_summary SET comments='@{c1}' WHERE location='@{c2}'</update>
<insert>INSERT INTO db_summary {comments} VALUES '@{c1}' </insert>

<WebMessage name="WriteBackNew">
<writeBack connectionPool="Connection Pool">
<update>UPDATE report_comments SET comments='@{c1}' WHERE username='@{c0}'</update>
<insert>INSERT INTO report_comments {comments} VALUES ('@{c1}') </insert>

Note: It’s all are case sensitive and red lined letters are give as above. After that restart all the OBIEE Server (Java Host, OC4J, BI Server etc.)
Note1: As Button Text in Presentation Layer :system="WriteBack"  and
As Template Name in Presentation Layer : <WebMessage name="WriteBackNew">
 4)      Choose value Interaction Type as Writ Back and field size like give screen

5)      Look at the given screen and enable the writeback option and give the Write Back Button name as per the WritBack.xml file.
6)      Finally I will get like this kind of screen ,write u r  comments on this text field and click WriteBack Button it will save in the Data base back end operation.

In DB result will be,

No comments:

Post a Comment