Set Up the Data Model

Make sure the Repository Creation Utility (RCU) has been successfully run while installing Oracle Business Intelligence Enterprise Edition. You should have the prefix_BIPLATFORM schema installed with the following tables in it:

• S_NQ_ACCT
• S_NQ_DB_ACCT
• S_NQ_INITBLOCK

1. Go to OBIEE_HOME/bi/bifoundation/samples/usagetracking.
2. Extract the UsageTracking-datafiles.zip archive.
3. Connect to the prefix_BIPLATFORM schema and execute the following SQL scripts in order:
   1. Oracle_create_nQ_Calendar.sql
   2. Oracle_create_nQ_Clock.sql
   3. Oracle_nQ_Calendar.sql
   4. Oracle_nQ_Clock.sql
4. Create a view in the prefix_BIPLATFORM schema:

   CREATE OR REPLACE VIEW nq_login_group AS SELECT DISTINCT user_name AS login FROM s_nq_acct;