Oracle^® Business Intelligence Presentation Services Administration Guide > Administering Oracle BI Dashboards > Configuring Report Write Back >

Write Back Configuration Tasks

The process of configuring write back fields consists of the following tasks. You need to customize these tasks for your specific implementation:

1. Assess the reporting needs in your organization and make a list of write back fields needed and the reports in which they should appear.
2. Create a physical table in your database that has a column for each write back field needed. In the table create statement, Oracle recommends that you make the write back fields non-null-able.

   NOTE:  For optimum security, store write-back database tables in a unique database instance.

3. Using the Administration Tool, configure the new table:
   1. Map the physical table into the logical model so that the logical fact columns are exposed and aggregate properly in the appropriate dimensions.
   2. Disable the Make Table Cacheable property for the write back table in the Physical Table window. This ensures that data written back to the database is displayed to the user, and not a cached value.
   3. Enable write back for the connection pool.
   4. Set up the content filters so users can only access records appropriate to their position. For example, sales representatives can view only their own records, but the sales managers can view records for their direct reports.

      For more information on the specific procedures, read Oracle Business Intelligence Server Administration Guide.

4. Create a write back template that specifies the SQL necessary to both insert and update values into the table you created. For more information, read Creating a Write Back Template.
5. In Oracle BI Presentation Services, grant write back privileges:
   1. For administrators and report writers, enable the Manage Write Back privilege. This action enables the Write Back properties window in Answers and enables the Write Back interaction type for columns.
   2. For administrators, report writers, and selected users, enable the Write Back to Database privilege. This action enables the user interface controls for write back (fields being editable and the presence of the write back button), and enables the server call that writes data back to the database.

      For more information on granting privileges, read Setting Privileges in Oracle BI Presentation Services Administration.

6. In Answers, configure write back reports:
   1. Create a report that contains a table view that uses the new columns.
   2. In the report, for each new column, edit the column format. Set the Column Interactions field to Write Back.
   3. If necessary, set key columns to be Hidden Keys in the column format dialog.
   4. Edit the Table View properties, enabling the write back feature, and specifying the name of the write back template, and the text for the write back button.
   5. Save the report.
   6. Embed the report in a dashboard page.

      For more information on creating reports, read Oracle Business Intelligence Answers, Delivers, and Interactive Dashboards User Guide.