Create Dimension Augmentation Type

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

Ensure that the custom dimensions that you create in augmentations are used by facts. If they aren’t used, then the custom dimensions aren’t visible in the subject areas. See Create Fact Augmentation Type.

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 Dimension in Augmentation Type to add a new dimension 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 dimension, 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.
  8. 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, Customer Class Code.
    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, Customer_Class_D. 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.