Create the OBIEE Topics views

On the Empirica Signal application server, locate the populate_obiee_topics.sql file in the contents extracted from the Database.zip file.
Open the populate_obiee_topics.sql file in a text editor.
Modify the following properties as needed for your environment:
DEFINE TOPIC_WORKFLOW = '<topic workflow account>';

DEFINE SIGNAL = '<Signal account>';
In a command prompt window, execute the populate_obiee_topics.sql script as the database user you created in Create the OBIEE Topics database account, for example:
$ sqlplus OBIEE_<topic workflow account>_<topic workflow ID>@<TNS name for database connection> @populate_obiee_topics.sql

A password prompt appears.
Enter the password for the OBIEE_<topic workflow account>_<topic workflow ID> database account that you created in Create the OBIEE Topics database account.
An ID prompt appears.
Enter the topic workflow configuration ID that you entered in Create the OBIEE Topics database account.
After the script runs, the populate_obiee_topics.log file is created.