Usage Tracking Settings In OBIEE NQSConfig.INI File


IN NQSConfig.INI sample working settings
[ USAGE_TRACKING ]
ENABLE = YES;
//==============================================================================
// Parameters used for writing data to a flat file (i.e. DIRECT_INSERT = NO).
//
STORAGE_DIRECTORY = ;
CHECKPOINT_INTERVAL_MINUTES = 5;
FILE_ROLLOVER_INTERVAL_MINUTES = 30;
CODE_PAGE = “ANSI”; // ANSI, UTF8, 1252, etc.
//
//==============================================================================
DIRECT_INSERT = YES;
//==============================================================================
// Parameters used for inserting data into a table (i.e. DIRECT_INSERT = YES).
PHYSICAL_TABLE_NAME = “OBI Usage Tracking”.”Catalog”.”dbo”.”S_NQ_ACCT” ;
CONNECTION_POOL = “OBI Usage Tracking”.”Usage Tracking Writer Connection Pool” ;
BUFFER_SIZE = 10 MB ;
BUFFER_TIME_LIMIT_SECONDS = 5 ;
NUM_INSERT_THREADS = 5 ;
MAX_INSERTS_PER_TRANSACTION = 1 ;
//==============================================================================
IN the physical layer the folder structure is as follows: