Follow the steps, screenshots and other referenced posts to configure write back in OBIEE reports.
First, you should choose a report in Answers to be able to writing back to the database.
- Go to the Table Component
- Click on the write back properties icon.Remark that each column have on this head a letter C and a number (Ex. c1, C2, … )
- Fill the template name with for example:SetWriteBackValue. (This name will indicate later the statement to update or insert in the database)
- Set to “write back” the value integration type of the column you want to be able to update.
Also refer the below mentioned topics to get more knowledge on Write Back.