Oracle^® Business Intelligence Data Warehouse Administration Console Guide > Overview of the DAC Interface > Using the DAC Query Functionality >

Using Flat Views Querying

You can use the Flat Views query feature to query for various objects, modify data, and do mass updates. This feature is available in the right-click menu in the Tables, Indices, and Tasks tabs of the Design view. The Flat Views right-click command is context-sensitive and allows you to query only on certain columns.

You can modify individual records in the query results window, or you can use the Update Records right-click command to update multiple records.

To update multiple records using the Flat Views query feature

1. In the DAC, right-click in the Tables, Tasks or Indices tab.
2. Select Flat Views, and then select a context-sensitive column on which you want to query.
3. In the query dialog box, enter search criteria, and click Go.
4. In the query results dialog box, right-click and select Update Records.
5. In the Update Record Set dialog box, select the column you want to update, and then click Set Value.
6. Enter a value for the column.
7. To update records that are referenced objects, select Update Referenced Records.

   If you select this check box, referenced objects as well as original and cloned objects will be updated. The referenced objects will become clones, and the ownership column for these records will be updated to reflect the new ownership.

   If you do not select this check box, only the columns in records that are original or cloned objects (objects owned by the source system container) will be modified.

8. Click OK.
9. Click Yes when asked if you want to proceed.

   An informational message tells you which records were updated.

10. Click OK to close the window.