OBIEE Write Back

We were trying to implement an update of multiple columns in a single update.

A few things to remember:
1. The XML is case sensitive. (If you use a 'C' instead of a 'c' your XML will not work correctly.
2. Each column that has write back enabled, should have a corresponding SQL entry in the XML template.
3. If there is a text entry being written back dont forget to put quotes around the dynamic column name.
4. Everytime you change columns in the report, the columns numbers change so make sure the XML template and the column names match.
5. The XML template should be saved in : D:\OracleBI\web\msgdb\customMessages
Its name can be anything.xml
6. the template name is: , this will be the same name used when specifying write back features.
7. A great source for creating the write back functionality in OBIEE is Venkat's post at: http://oraclebizint.wordpress.com/2007/09/20/oracle-bi-ee-101332-write-back-option-budgetingplanning/
8. For an example of the XML used for update please see the next post.

Anisha