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. 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 for Data Model Column from the Console.

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