Oracle® Business Intelligence Server Administration Guide > Oracle BI Server Usage Tracking Data Descriptions and Using the Log File Method >

Create Table Scripts for Usage Tracking Data


The OracleBI\server\Schema folder contains the following Create Table scripts for Oracle, DB2, SQL Server and Teradata:

  • SAACCT.Oracle.sql for Oracle
  • SAACCT.DB2.sql for DB2
  • SAACCT.MSSQL.sql for SQL Server
  • SAACCT.Teradata.sql

The sample scripts set the usage tracking table name to S_NQ_ACCT. For sites that have Oracle BI Applications, this is the name used in the Oracle BI repository. Sites that build their own repositories may change the name of the usage tracking table. The table name must match the name used in the corresponding repository.

Oracle® Business Intelligence Server Administration Guide Copyright © 2007, Oracle. All rights reserved.