Go to main content
Enabling Write Back On Columns
You can configure individual logical columns so that users in Oracle BI Presentation Services can update column data and write the changes back to the data source.
To enable write back on a particular column, you must select the
Writeable option for the logical column, and enable the Read/Write permission for the corresponding presentation column. You must also disable caching on the corresponding physical table.
You must perform additional tasks to enable write back in
Oracle BI Presentation Services. See Configuring for Write Back in Analyses and Dashboards in for full information. System Administrator's Guide for Oracle Business Intelligence Enterprise Edition
In the Administration Tool, in the Physical layer, double-click the physical table that contains the column for which you want to enable write back.
On the General tab of the Physical Table dialog, ensure that Cacheable is not selected. Deselecting this option ensures that Oracle BI Presentation Services users can see updates immediately.
In the Business Model and Mapping layer, double-click the corresponding logical column.
The image shows the Logical Column dialog.
In the Logical Column dialog, select Writeable, then click OK.
In the Presentation layer, double-click the column that corresponds to the logical column for which you enabled write back. The Presentation Column dialog opens.
Read/Write permission for the appropriate users and application roles.
The image shows the Permissions dialog with the Read/Write permission selected..
Click OK in the Permissions dialog.
Click OK in the Presentation Column dialog.
Scripting on this page enhances content navigation, but does not change the content in any way.