Tips on Using Synonyms for Home Page and AI Assistant Search

Use the following tips to help you create and assign data column synonyms.

If you own or have read-write access to a dataset, you can assign synonyms to its columns from the dataset's Search settings. See Specify Synonyms for Dataset Columns.

If you're an Administrator, you can assign synonyms to a data model from the Console's Search Index specifications. See Specify Synonyms.

If you're a business user, you can use the CSV file provided by an Administrator to assign synonyms to a data model. After you've finished assigning synonyms, the Administrator imports the CSV file into Oracle Analytics. See Specify Synonyms in an Exported CSV File.

Tips on specifying synonyms for column names:

  • Enter one or multiple synonyms. For example, for a Yield column you might specify revenue and income.
  • When updating a CSV file to add multiple synonyms to a data model column, use a comma to separate the synonyms. For example, revenue,income.
  • Synonyms can be up to 50 characters.
  • You can specify a maximum of 20 synonyms for each column name.
  • You can use upper or lowercase when you specify synonyms. The home page and Oracle Analytics AI Assistant search isn't case sensitive.

You can't base synonyms on:

  • Analytical functions, for example, sum, AND, OR, NOT, BETWEEN, IN, IS NULL, LIKE, Aggregate At, Aggregate By.
  • Analytical terms, for example, null.
  • Articles, prepositions, pronouns, and conjunctions that are usually removed before processing natural language (also known as stop words). For example, a, an, and, are, as, at, be, but, by.
  • Boolean function names, for example, true, false, yes, no.
  • Date formats, for example, nn/nnnn, nnnn/nn, nn/nn/nnnn, nnnn/nn/nn where n is an integer.
  • Integers, for example, 123 or 123 456.
  • Special characters, for example, `!@#$%^&*()+=[]{};\':"\\|,<>/?~.