Creating 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 Creating 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.
Type the password for the OBIEE_<topic workflow account>_<topic workflow ID> database account that you created in Creating the OBIEE Topics database account.
An ID prompt appears.
Type the topic workflow configuration ID that you typed in Creating the OBIEE Topics database account.
After the script runs, the populate_obiee_topics.log file is created.