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.
Working with Digit-only Keys
When you add Custom Knowledge to Oracle Analytics, you might 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 (that is, retaining "00" at the start of the code) 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