Enable the Usage Tracking Feature in the NQSConfig.INI File

1. Go to OBIEE_HOME/user_projects/domains/bi_domain/config/fmwconfig/biconfig/OBIS/.
2. Open the NQSConfig.INI file in a text editor.
3. In the [Usage Tracking] section set the ENABLE parameter to YES.
4. Set the DIRECT_INSERT parameter to YES.
5. 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"
6. 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"
7. 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"
8. 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";

9. 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.