Tips on Using Synonyms for Search

Use the following tips to help you create and assign data column synonyms for home page 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 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, `!@#$%^&*()+=[]{};\':"\\|,<>/?~.