Oracle Analytics Cloud and Server

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

Write back functionality Issue

Received Response
31
Views
6
Comments
User_JL3CW
User_JL3CW Rank 6 - Analytics Lead

Hi,

I have a report with writable columns. After entering text in the 3 write back columns, the text is disappearing.

I have queried in the oracle database. It's not updated.

pastedImage_0.png

I have entered the below text in the above report, but disappeared after click of SAVE button.

pastedImage_1.png

I am using OBIEE 11.1.1.7 version.  DB is ORACLE DB.

Regards,

Chandra.

Answers

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    Writeback is a fair old length of pipe.

    1. check your user has rights

    2. check the connection pool can writeback

    3. check the insert in the associated file against the db to ensure the syntax is valid

    4. check the field mappings in the associated file to the fields in your answers report correspond

    5. Wonder why you are not using a tool more suited to purpose like Apex for this....

  • User_JL3CW
    User_JL3CW Rank 6 - Analytics Lead

    Hi,

    1. check your user has rights  - YES

    2. check the connection pool can writeback - HOW TO CHECK THIS?

    3. check the insert in the associated file against the db to ensure the syntax is valid

    -

    I have used UPDATE statement in write back xml file.

    I have tested update statement in oracle database. It's updating properly.

    4. check the field mappings in the associated file to the fields in your answers report correspond

    - Mappings are proper.

    Regards,

    Chandra

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    On 2  - the connection pool that you underlying table connects to in the rpd, it has been a while but I am fairly certain you have to configure there to enable writeback, as I usually create a specialised connection pool for the purpose.

  • User_JL3CW
    User_JL3CW Rank 6 - Analytics Lead

    Hi,

    Configure means...In the connection pool setting i have given DB user credentials and in the Write Back Tab it shows as shown below attached.

    pastedImage_0.png

    Regards,

    Chandra.

  • User_JL3CW
    User_JL3CW Rank 6 - Analytics Lead

    Please confirm do i need to count hidden columns also.

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    Yes, you do.

    And this is from memory, but check the connection settings also, I am fairly sure there is an allow writeback tickbox in the back end also... I don't have access to OBIEE here to check.