Monday, January 31, 2011

OBIEE - Usage Tracking

-- Install/Create the metadata tables required for Usage Tracking.
-- 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 "".""."
" ; CONNECTION_POOL                = "OBI Usage Tracking"."Usage Tracking Writer Connection Pool" ;