1. Building Semantic Models in Oracle Analytics Server
  2. Create and Build Your Model
  3. Build a Semantic Model's Logical Layer
  4. Enable Write Back On Columns

Enable Write Back On Columns

You can configure individual columns so that analyses and dashboard users can update column data and write the changes back to the data source.

Enabling write back is a three step process where you disable caching on the corresponding physical table so that users can immediately see data updates, modify the logical column Writeable field, and assign application roles and users the Read/Write permission to the corresponding presentation column.

You must perform additional tasks to enable write back in Oracle Analytics. See Enable Write Back in Analyses and Dashboards.

  1. On the Home page, click Navigator and then click Semantic Models.
  2. In the Semantic Models page, click a semantic model to open it.
  3. Click Physical Layer.
  4. In the Physical Layer pane, browse for and double-click the physical table with the column that you want to enable write back for.
  5. In the physical table, click the Columns tab.
  6. Click the Caching field and select Do not cache.
  7. To locate a list of logical tables that use the physical table as their source, go to the Physical Layer pane, right-click the physical table, click Show Related, then Logical, and then Logical Table.
  8. In the table list, locate and click the logical table that contains the logical column that you want to set for write back.
  9. In the logical table, click the Columns tab.
  10. In the columns list, click a column to select it and then click Detail view to open the properties pane.
  11. In the logical column's General properties click the Writeable field.
  12. In the Semantic Modeler's left pane, click Presentation Layer and locate and double-click the logical table that contains the logical column that you want to set up for write back.
  13. In the columns list, click the presentation column that corresponds to the logical column that you're setting up write back for, and then click Detail view to open the properties pane.
  14. Scroll to Permissions and deselect the Same permission as table field,
  15. In the Permissions table, specify which roles have Read-Write permissions.
  16. Click Save.