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 System Administrator's Guide for Oracle Business Intelligence Enterprise Edition for full information.

  1. 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.
  2. 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.
  3. In the Business Model and Mapping layer, double-click the corresponding logical column.
  4. In the Logical Column dialog, select Writeable, then click OK.
  5. 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.
  6. Click Permissions.
  7. Select the Read/Write permission for the appropriate users and application roles.

    The image shows the Permissions dialog with the Read/Write permission selected..

  8. Click OK in the Permissions dialog.
  9. Click OK in the Presentation Column dialog.