How to enable usage tracking for keep user log and enable for insert log direct to table.
Propose of this activity help you to analyze user log.
This is guide line for set Aggregate table, Cache setting!
1. Create the
usage tracking table
OBIEE path\bifoundation\OracleBIServerComponent\coreapplication_obis1\
schema\SAACCT.Oracle.sql; << this case for Oracle DB
2. Import the
usage tracking table.
Import table that you create to Physical layer.
3. Build a
usage tracking business model.
Build a usage tracking business model using
the columns in the S_NQ_ACCT table
4. Enable
usage tracking.
With modify the NQSConfig.ini file to enable usage tracking.
5. Enable direct insertion.
With modify the NQSConfig.ini file to enable usage tracking.
5. Enable direct insertion.
With Set the DIRECT_INSERT parameter to YES
6. Set the
physical table parameter.
Set the PHYSICAL_TABLE_NAME parameter to specify the table into which to insert records corresponding to the query statistics.
The table name is the fully qualified name as it appears in the Physical layer of the Administration Tool.
Set the PHYSICAL_TABLE_NAME parameter to specify the table into which to insert records corresponding to the query statistics.
The table name is the fully qualified name as it appears in the Physical layer of the Administration Tool.
7. Set the
connection pool parameter.
Set the CONNECTION_POOL parameter to specify the connection pool to use for inserting records into the usage tracking table.
The connection pool is the fully qualified name as it appears in the Physical layer of the Administration Tool.
Set the CONNECTION_POOL parameter to specify the connection pool to use for inserting records into the usage tracking table.
The connection pool is the fully qualified name as it appears in the Physical layer of the Administration Tool.
8. Set
additional parameters.
BUFFER_SIZE
BUFFER_TIME_LIMIT_SECONDS
NUM_INSERT_THREADS
MAX_INSERTS_PER_TRANSACTION
9. Test the
results.
ไม่มีความคิดเห็น:
แสดงความคิดเห็น