-- Run the following scripts/sql in the database.
From : C:\oracle\OracleBI\server\Sample\usagetracking\SQL_Server_Time
Oracle_create_nQ_Calendar.sql = S_ETL_DAY
Oracle_create_nQ_Clock.sql = S_ETL_TIME_DAY
Oracle_nQ_Calendar.sql = Inserts data into
Oracle_nQ_Clock.sql = Inserts data into
From : C:\oracle\OracleBI\server\Schema
SAACCT.Oracle.sql = Creates NQ_ACCT
Oracle_alter_nq_acct.sql - alters the table default values.
-- Taken from SQLServer_create_nQ_UserGroup.sql
create view NQ_LOGIN_GROUP as
select distinct USER_NAME as LOGIN, USER_NAME as RESP
from S_NQ_ACCT;
Tables: S_NQ_ACCT, S_NQ_ERR_MSG, S_NQ_INSTANCE, S_NQ_JOB, S_NQ_JOB_PARAM
Views : NQ_LOGIN_GROUP
--Changes in the NQSConfig.INI file
[ USAGE_TRACKING ]
ENABLE = YES;
DIRECT_INSERT = YES;
//==============================================================================
// Parameters used for inserting data into a table (i.e. DIRECT_INSERT = YES).
//
PHYSICAL_TABLE_NAME = "OBI Usage Tracking"."KINDLE_CM_DDL"."S_NQ_ACCT" ; // Or "