OBIEE Writeback Issue

Md. Altas

Hi

We are upgrading OBIEE from 11.1.1.6 to 11.1.1.9.

We have few reports with writeback functionality.

However after migration, the 'Update' button on the reports is not showing up on new reports.

Is there anything different need to do for 11.1.1.9 for writeback?

Thanks

cesar.advincula.o

Hello,

Did you migrate the xml template in the custommessage directory?

Did you check the permission in the logical column in your rpd to writeback?

Did you check the administration -> manage privilege -> writeback functionality?

Kind Regards,

Md. Altas

Our Admin missed the last step !!!

Md. Altas

Appreciate if you can help on the next step.

I am not getting all the buttons.

When I click on 'Update' then the field is enabled for edit.

But I cannot edit the field. It is allowing me to edit the field at all.

Below is the writeback template. I want to use generic columns like @{c1} etc instead of actual column id.

We need to migrate this to new instances. Hence we need the generic column names.

<?xml version="1.0" encoding="utf-8"?>

<WebMessageTables xmlns:sawm="com.siebel.analytics.web/message/v1">

<WebMessageTable lang="en-us" system="WriteBack" table="Messages">

<WebMessage name="REGUPDATE">

<XML>

<writeBack connectionPool="OPN_Conn_Pool">

<insert></insert>

<update>UPDATE OPN.OPN_CUST_FIELDS SET REGION=@{c2} WHERE CUST_NAME=@{c0} AND CUST_SITE=@{c1} </update>

</writeBack>

</XML>

</WebMessage>

</WebMessageTable>

</WebMessageTables>

Appreciate any help on this please.

cesar.advincula.o

Of course,

just modify the XML..

and push "Apply XML" button..