Parameters

The parameters are in the NqsConfig.ini file. You must configure the database connection values in “Usage Tracking”.“Connection Pool” for database where usage tracking data would be collected

Example of the usage tracking section of OBIEE 11g.

###############################################################################
#
#  Usage Tracking Section
#
#  Collect usage statistics on each logical query submitted to the
#  server.
#
###############################################################################

[USAGE_TRACKING]

ENABLE = YES;  # This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control

#==============================================================================
# Parameters used for writing data to a flat file (i.e. DIRECT_INSERT = NO).
#
# Note that the directory should be relative to the instance directory.
# In general, we prefer directo insert to flat files.  If you are working in
# a cluster, it is strongly recommended you use direct insert.  If there is
# only one Oracle BI Server instance, then you may use flat file data.
# The directory is then assumed relative to the process instance.  For
# example, "UTData" is resolved to
# "$(ORACLE_INSTANCE)/bifoundation/OracleBIServerComponent/<instance_name>/UTData"
STORAGE_DIRECTORY = "<directory path>";  
CHECKPOINT_INTERVAL_MINUTES = 5;  
FILE_ROLLOVER_INTERVAL_MINUTES = 30;  
CODE_PAGE = "ANSI";  # ANSI, UTF8, 1252, etc.
#
#==============================================================================

DIRECT_INSERT = YES;  # This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control

#==============================================================================
#  Parameters used for inserting data into a table (i.e. DIRECT_INSERT = YES).
#
# This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control
PHYSICAL_TABLE_NAME = "EXAREPO"."EXA1_BIPLATFORM"."S_NQ_ACCT";  # Or "<Database>"."<Schema>"."<Table>" 
# This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control
CONNECTION_POOL = "EXAREPO"."EXA_USAGE"; 
BUFFER_SIZE = 250 MB;  
BUFFER_TIME_LIMIT_SECONDS = 5;  
NUM_INSERT_THREADS = 5;  
MAX_INSERTS_PER_TRANSACTION = 1;  
#
#==============================================================================

# This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control
SUMMARY_STATISTICS_LOGGING = YES;  
# This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control
SUMMARY_ADVISOR_TABLE_NAME = "EXAREPO"."EXA1_BIPLATFORM"."S_NQ_SUMMARY_ADVISOR";  # Or "<Database>"."<Schema>"."<Table>" ;