Write Back is the ability to enter or update values directly into a report and have those values stored directly in to the database. In order to
implement this feature in OBIEE we have to make some changes in the repository as well as in the presentation services layers.
Steps for Write Back
Making the table uncacheable from the physical layer of the repository.
Configuring the write back in the connection pool.
Granting the privileges of write back to the user from the Presentation Services.
Creating a XML Template and specifying the insert and update queries for write back.
Enabling write back from the column properties of the column in the request.
Specifying the template name in the table view write back properties of the request.
For more Information refer following links:
http://oraclebizint.wordpress.com/2007/09/20/oracle-bi-ee-101332-write-back-option-budgetingplanning/
http://kpipartners.blogspot.com/2009/09/writeback-in-obiee.html
http://forums.oracle.com/forums/thread.jspa?threadID=2211115&tstart=15&start=15
http://gerardnico.com/wiki/dat/obiee/write_back
Until Next Post... :)
No comments:
Post a Comment