Enable Writeback based on the selections on dropdown

Jack

Hi

We have a requirement like we will have a dashboard page where we will have 3 prompts with dropdown and based on those selection we have to insert data. Now we have to insert back in DB table both slected values and inserted values.

I have idea like how to insert directly in DB table using writeback option, but i am not sure on how to writeback selected values through dropdown into database table.

Can anyone suggest.

[Deleted User]

The built-in writeback is not and was never intended as a data entry tool. It's analytics, not an OLTP!

Use APEX and you will be a LOT happier with the result!

Jack

is it not doable in OBIEE, can you please confirm

[Deleted User]

It is but I would not do it in an *analytical* tool.

[Deleted User]

It is but I would not do it in an *analytical* tool.

[Deleted User]

It is but I would not do it in an *analytical* tool.

Jack

but we need to implement in obiee, do any one have suggestion on this

[Deleted User]

Use the prompt values in variables and have it passed to the column formulas

Jack

Thank you.

When i am trying to writeback, i am getting error as "The system is unable to read the Write Back Template 'Reverse'. Please contact your system administrator."  in obiee11g. Can you please suggest where I am going wrong

Placed xml template in below paths too

obi11g/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/msgdb/customMessages

obi11g//bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/analyticsRes/customMessages

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

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

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

-<WebMessage name="Reverse">

-<XML>

-<writeBack connectionPool="Oracle Data Warehouse Connection Pool">

<insert>insert into table (column1) values(@{cbb79f33511e76a58} )</insert>

<update>UPDATE table SET column1= @{cbb79f33511e76a58} </update>

</writeBack>

</XML>

</WebMessage>

</WebMessageTable>

</WebMessageTables>