2 Prepare the Empirica Signal data account

In this step, you create an OBIEE database account for the Empirica Signal and Topics application, and then populate the database account with views that point to data items in your chosen topic workflow configuration for reporting.

This chapter includes the following sections:

• Creating the OBIEE Topics database account

• Creating the OBIEE Topics views

Creating the OBIEE Topics database account

1. Extract the contents of the Database.zip file on your Empirica Signal application server.

2. Open the create_topics_user_obiee.sql file in a text editor.

3. Verify that the following properties are set to the appropriate values for your environment, and edit the values if necessary:

   DEFINE TOPIC_WORKFLOW = '<topic workflow account>';

   DEFINE SIGNAL = '<Signal account>';

   DEFINE TABLESPACE = '<tablespace>';

4. Open a Command Prompt window (for example, PuTTY) and execute the create_topics_user_obiee.sql script as the Oracle system user:

   
   

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

   
   

   $sqlplus system@<TNS name for database connection> @create_topics_user_obiee.sql

5. When prompted, type the Oracle system account password.

   A list of topic workflow configuration names and IDs appears.

6. When prompted, type the target topic workflow configuration ID.

   The script creates the OBIEE_<topic workflow account>_<topic workflow ID> database account.

7. When prompted, choose and type a password for the OBIEE_<topic workflow account>_<topic workflow ID> database account.

   Record this password for use in the next section and later.

   The script completes, and creates the create_topics_user_obiee.log file.

Creating the OBIEE Topics views

1. On the Empirica Signal application server, locate the populate_obiee_topics.sql file in the contents extracted from the Database.zip file.

2. Open the populate_obiee_topics.sql file in a text editor.

3. Verify that the following properties are set to the appropriate values for your environment, editing the values as necessary:

   DEFINE TOPIC_WORKFLOW = '<topic workflow account>';

   DEFINE SIGNAL = '<Signal account>';

4. Open a command prompt window and execute the populate_obiee_topics.sql script as the database user created in Creating the OBIEE Topics database account:

   $sqlplus OBIEE_<topic workflow account>_<topic workflow ID>@<TNS name for database connection> @populate_obiee_topics.sql

5. When prompted, type the password for the OBIEE_<topic workflow account>_<topic workflow ID> database account that you created in Creating the OBIEE Topics database account.

6. When prompted, type the same topic workflow configuration ID that you entered in step 6 in Creating the OBIEE Topics database account.

   The script completes, and creates the populate_obiee_topics.log file.