Oracle Business Intelligence Applications

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Business Intelligence Applications

Categories

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

Writeback functionality issue

Received Response
11
Views
2
Comments
3427576
3427576 Rank 4 - Community Specialist
in Oracle Business Intelligence Applications

Hi,

I have enabled writeback functionality of a column in the BMM layer and deployed.

1.JPG

Pulled this column in a new analysis. I am able to check/uncheck the writeback option from the column properties.

2.JPG

However, I created another analysis using CREATE DIRECT DATABASE QUERY and added the same column in my sql query. The writeback option here is disabled. Hence, I am not able to check and uncheck the box.

3.JPG

Please advise with the steps to enable the writeback in the sql based report or any other work around which allows me to update into the physical table using the CREATE DIRECT DATABASE QUERY analysis. FYI, I am using the following version Oracle Business Intelligence 12.2.1.2.0

Thanks in Advance

Answers

  • 3427576
    3427576 Rank 4 - Community Specialist

    Any insight would be really helpful. Thanks a lot!

  • 2907462
    2907462 Rank 1 - Community Starter

    Hi,

    Are you able to see the Advanced tab, Just create a XML for Insert and place it under db_Messages path.

    In RPD have you given Allow Privileges and execute direct base analysis as Allow.

    Regards,

    Vijay