- Dashboards User's Guide
- Enable the Oracle Healthcare Foundation SSA Usage Tracking
- Enable the Usage Tracking Feature in the NQSConfig.INI File
Enable the Usage Tracking Feature in the NQSConfig.INI File
- Go to
OBIEE_HOME/user_projects/domains/bi_domain/config/fmwconfig/biconfig/OBIS/
. - Open the NQSConfig.INI file in a text editor.
- In the [Usage Tracking] section set the ENABLE parameter to YES.
- Set the DIRECT_INSERT parameter to YES.
- Set the PHYSICAL_TABLE_NAME parameter to point to the
S_NQ_ACCT table in the
prefix_BIPLATFORM
schema in the following format: "Database"."Catalog"."Schema"."Table";Use the database, catalog, schema, and table names predefined in the Oracle Healthcare Foundation SSA RPD file:
- Database:
"OHF Usage Tracking"
- Catalog:
"Catalog"
- Schema:
"dbo"
- Table Name:
"S_NQ_ACCT"
- Database:
- Set the CONNECTION_POOL parameter in the following format
"Database"."Connection Pool";
Use the database and connection pool values predefined in the Oracle Healthcare Foundation SSA RPD file:
- Database:
"OHF Usage Tracking"
- Connection Pool:
"OHF Usage Tracking Connection Pool"
- Database:
- Uncomment the INIT_BLOCK_TABLE_NAME parameter and set it
to point to the S_NQ_INITBLOCK table in the
prefix_BIPLATFORM
schema in the following format: "Database"."Catalog"."Schema"."Table";Use the following values:
- Database:
"OHF Usage Tracking"
- Catalog:
"Catalog"
- Schema:
"dbo"
- Table Name:
"S_NQ_INITBLOCK"
- Database:
- Uncomment the INIT_BLOCK_CONNECTION_POOL parameter and set
it to refer to the connection pool for writing statuses to the S_NQ_INITBLOCK
table in the
prefix_BIPLATFORM
schema in the following format: "Database"."Connection Pool";Use the database and connection pool values predefined in the Oracle Healthcare Foundation SSA RPD file:
- Database:
"OHF Usage Tracking"
- Connection Pool:
"OHF Usage Tracking Connection Pool"
The above parameters should be set as below:
=============================================================================== # Parameters used for inserting data into the table (i.e. DIRECT_INSERT = YES). # Init-Block Tracking Options are commented out and as a result disabled. # To enable Init-Block Tracking Feature, define the two parameters for # Init-Block, INIT_BLOCK_TABLE_NAME and INIT_BLOCK_CONNECTION_POOL. PHYSICAL_TABLE_NAME = "OHF Usage Tracking"."Catalog"."dbo"."S_NQ_ACCT"; # Or "Database"."Schema"."Table" ; CONNECTION_POOL = "OHF Usage Tracking"."OHF Usage Tracking Connection Pool"; INIT_BLOCK_TABLE_NAME = "OHF Usage Tracking"."Catalog"."dbo"."S_NQ_INITBLOCK" ; # Or "<Database>"."<Schema>"."<Table>" ; INIT_BLOCK_CONNECTION_POOL = "OHF Usage Tracking"."OHF Usage Tracking Connection Pool";
- Database:
- Stop and restart the Oracle Business Intelligence Enterprise
Edition Services using the stop and start scripts available in
OBIEE_HOME/user_projects/domains/bi_domain/bitools/bin
.