I manage to set up usage tracking on OBIEE 220.127.116.11.0. I am able to get records in the table S_NQ_ACCT, however S_NQ_DB_ACCT is not working. I found why is not working, but I am not sure how to fix it. In the nqserver.log I am getting the error message:
[nQSError: 17001] Oracle Error code: 2291, message: ORA-02291: integrity constraint (TEST2_BIPLATFORM.FK_S_NQ_DB_ACCT) violated - parent key not found
at OCI call OCIStmtExecute: INSERT INTO S_NQ_DB_ACCT (ID,LOGICAL_QUERY_ID,QUERY_TEXT,QUERY_BLOB,TIME_SEC,ROW_COUNT,START_TS,START_DT,START_HOUR_MIN,END_TS,END_DT,END_HOUR_MIN) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12).