Add Custom Knowledge for Data Enrichment

Add custom knowledge to Oracle Analytics to augment the system knowledge. For example, you might add a custom knowledge reference that classifies prescription medication into USP drug categories Analgesics or Opioid.

Tutorial

Custom knowledge enables the Oracle Analytics semantic profiler to identify more business-specific semantic types and make more relevant and governed enrichment recommendations.

Before you start, download your custom knowledge reference files (in CSV format) and make them available locally for upload. You can also create your own custom knowledge reference files in CSV format. See Custom Knowledge Recommendations.

1. In the Oracle Analytics Home page, click the Navigator, and then click Console.
2. Click Reference Knowledge.
3. Under Custom Knowledge, click Add Custom Knowledge.
4. In the Open dialog, navigate to and select your custom knowledge CSV file, then click Open.
5. In the Create Custom Knowledge from dialog, specify a name, verify the upload options, then click OK.

   The Custom Knowledge page lists the new file with the Include option selected. When content authors enrich datasets, Oracle Analytics presents enrichment recommendations based on this data.

Working with Digit-only Keys

When you add Custom Knowledge to Oracle Analytics, sometimes you want to profile digit-only or numeric keys without removing leading zeros, which is how Oracle Analytics usually ingests numbers. For example, you might want Oracle Analytics to ingest the UNSPSC classification code '0010101501' as '0010101501' rather than '10101501'. By retaining the full key in Reference Knowledge, workbook designers can access recommendations to enrich their data, which in this example provides UNSPSC data such as name, family, and class.

Tips on Adding Digit-only Keys

In the source file, define the key column as text and make it the first column. You don't have to change the format of the other columns in the file.

For example, in the UNSPSC classification codes dataset the Commodity column holds the key identifier for each row. The Commodity keys are numbers with leading zeros. Oracle Analytics treats the values in the Commodity column as an attribute.

Description of the illustration ingest-digit-data-1.png

When workbook designers add data based on this custom knowledge, the enrichment recommendations are appropriate for the data. In this example, enrichment recommendations for UNSPSC classification codes in the Commodity column enable you to enrich your visualization with commodity data such as name, family, and class.

Description of the illustration ingest-digit-data-2.png