Hello Experts,

Oracle Business Intelligence Version  11.1.1.7.150120. 

We have a requirement to enable writeback feature, for that we have followed all the necessary steps to enable that as follows.

RPD LEVEL:-

Step 1:Physical Layer - From Physical Table Properties Go to-> General tab dialog box. Uncheck Cacheable

Step 2: Business Model & Mapping Layer -  Logical Column Properties Go to-> General tab. Check Writable option.

Step 3: Presentation Layer - Presentation Column Properties Go to-> General tab -> Permissions -> Set permission -> Read / Write (Radio Button), on the User / Application Role which you want to authenticate for WriteBack feature.

Step 4: Presentation Layer - Go to -> Manage-> Identity Manager -> Identity Management (Left pane) -> Select Application Role (to which you need Write Back Permission) -> Permission -> Query Limits (tab) -> Select Database (to which you need direct database execution rights) -> Change option from ignore to allow to the field named "Execute Direct Database Requests".

Configuration Level:-

Step 1: Enable Write Back. Add the LightWriteback tag within  the serverinstance tag of instanceconfig.xml file  ( file path - $ORACLE_INSTANCE/config/OracleBIPresentationServicesComponent/coreapplication_obips1 )

<WebConfig xmlns="oracle.bi.presentation.services/config/v1.1">

   <ServerInstance>

<LightWriteback>true</LightWriteback>

</ServerInstance>

</WebConfig>

Step:2

created Writeback templet as mentioned in the oracle documentation and placed under

$ORACLE_INSTANCE/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/analyticsRes/customMessages

Changes in Analytics :

Step 1: Give Privilege to the Role for Write Back: Write back to database ( Administration -> Manage Privilege -> Write Back & add the role for writeback privilege).

And then Restarted all the services.

but still Writeback Radio button is not enabled for WriteBack Columns,  under column properties --> Writeback Tab.

Please provide your valuable suggestions to proceed further.