Tips on Using Synonyms for Search

Use the following tips to help you create and assign data column synonyms for home page and AI Assistants search.

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

If you're an administrator, you can assign synonyms to a data model from the Search Index page in the Console. See Specify Synonyms for Data Model Column from the Console.

If you're a business user, you can use the CSV file provided by your administrator to assign synonyms to a data model. After you've finished assigning synonyms, the administrator imports the CSV file into Oracle Analytics. See About Managing Data Model Indexing and Synonyms Using a 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. Home page and Oracle Analytics AI Assistants searches aren't case sensitive.

Don't base synonyms on the following:

• 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, `!@#$%^&*()+=[]{};\':"\\|,<>/?~.