1. Administering Data Integration for Oracle Enterprise Performance Management Cloud
  2. Reviewing Process Details and Viewing Results in the Workbench
  3. Using the Workbench
  4. Using the Workbench Workflow
  5. Viewing Target Data

Viewing Target Data

You can view specific details associated with target data used in the integration such as the dimensions to which data is loaded. In this view, you can also select a target row and view the source data associated with the item.

Note:

If you have a large volume of data to be viewed, make sure that there are no more than 5,000 rows in the target view. To ensure this, filter the data on the Workbench page.

Note:

For a Data Export to File application, set the Workflow mode to Full when you want to see the data in Workbench for testing purpose (by default the Workflow mode is Simple for a Data Export to File application. See Selecting the Workflow Mode in Administering Data Management for Oracle Enterprise Performance Management Cloud.

To display data in a target view:

  1. From the Data Integration home page, click Image shows Select icon. to the right of the integration, and then select Workbench.

  2. From the Actions drop-down, select Target View.

  3. Optional: To display the source data associated with a target row, click the target row.

    The source data information is displayed below the Target Data rows.

    Image shows the Target View page.