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:
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
I don't understand why you need to have each column in a seperate statement but can't get working either... I can get one but the min I add another column it errors? anyone?
ReplyDeletePlease can you elaborate your question?
ReplyDeleteThanks,
Hi I am new to OBIEE. I don't understand how to write the template. Many articles on the web says we should save the template in D:\OracleBI\web\msgdb\customMessages
ReplyDeleteCould you please explain how to create the template very first time?
Thank You