Creating the OBIEE Topics database account

On the Empirica Signal application server, unzip the Database.zip file.
Using a text editor, open the create_topics_user_obiee.sql file.
Modify the following properties as needed for your environment:
DEFINE TOPIC_WORKFLOW = '<topic workflow account>';

DEFINE SIGNAL = '<Signal account>';

DEFINE TABLESPACE = '<tablespace>';
In a command prompt window, execute the create_topics_user_obiee.sql script as the Oracle system user:
$ sqlplus system@<database_server_TNS name> @create_topics_user_obiee.sql

Note: The database may reside on a different server than the Signal server.

A password prompt appears.
Type the password for the Oracle system account.
A list of topic workflow configuration names and IDs appears, and an ID prompt appears.
Type the target topic workflow configuration ID.
The script creates the OBIEE_<topic workflow account>_<topic workflow ID> database user account.

A second password prompt appears.
Type a password for the OBIEE_<topic workflow account>_<topic workflow ID> database user account.
Record the password.
After the script runs, the create_topics_user_obiee.log file is created.