Create Fact Augmentation Type

You can augment your reports with datasets created by adding a new fact in the target instance.

If you've created custom dimensions for augmentations, then you can select such dimensions to map to the column that you identify as the Dimension entity type. This enables the custom dimensions to be visible in the subject areas.

You must ensure that any column with primary key doesn’t have null values, otherwise the extract process rejects the entire dataset or table. If there are multiple columns with primary keys, then you must ensure that none of those columns have null values. If any of them have null values, then Oracle Fusion Data Intelligence rejects the entire extraction job. If Oracle Fusion Data Intelligence rejects the extraction job, then the corresponding augmentation is also rejected.

Ensure that SME Options for Data Augmentation is enabled in Pipeline Features section under the Generally Available Features tab on the Enable Features page. See Enable Generally Available Features.

  1. In step 1 of the Data Augmentation wizard, select Create Fact in Augmentation Type to add a new fact table in the target instance.
  2. Select Supplemental Data (Regular) in Source Dataset Type.
  3. In Pillar, select a product pillar; for example, Enterprise Resource Planning.
  4. In Source Table Type, specify the source table type using either of the options:
    • Select System Provided and then in Source Table, select a table to which you want to add the new dimension.
    • Select Customer Provided and then in Source Table, enter the name of the table to which you want to add the new dimension.
  5. Optional: Select the Versioned Dataset check box to enable full load of the source table data everytime and then click Next.
  6. In step 2 of the wizard, select the check box for the attributes from the source table that you want in your new fact, and then click Next.
  7. In step 3 of the wizard, click Action icon for each of the selected attributes to specify the Type and Treat as settings and then click Next.
    Ensure that you select at least one attribute as a measure to proceed through the wizard.
  8. In step 5 of the wizard, specify the dimension in the data warehouse that you want to map to the column that you identified as the Dimension entity type and then click Next.
  9. In step 6 of the wizard, provide the following details and click Finish to save and schedule your data augmentation pipeline job:
    1. Name your augmentation pipeline job; for example, AP Distribution.
    2. Enter a suffix for the target table name using underscore in place of spaces between words and don’t use special characters; for example, AP_DISTRIBUTION_F. The augmentation process automatically creates the target table name.
    3. Provide a description.
    4. Select the functional area and one or multiple subject areas in which you want to include this augmentation pipeline job.
    5. Specify the options to save the data augmentation pipeline job without executing it, or schedule the execution date and time, or execute it immediately.