Enable Writeback based on the selections on dropdown — Oracle Analytics

Oracle Business Intelligence Applications

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Enable Writeback based on the selections on dropdown

Received Response
82
Views
8
Comments

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.

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    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
    Jack Rank 4 - Community Specialist

    is it not doable in OBIEE, can you please confirm

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

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

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

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

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

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

  • Jack
    Jack Rank 4 - Community Specialist

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

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

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

  • Jack
    Jack Rank 4 - Community Specialist

    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>