Oracle^® Business Intelligence Infrastructure Upgrade Guide > Performing an Oracle BI Infrastructure Upgrade >

Upgrading Usage Tracking Schemas

Oracle BI Infrastructure requires a number of setup tasks to enable usage tracking. Specific applications might require additional steps.

Oracle BI Infrastructure 10.1.3.2 adds the following columns to usage tracking:

• SAW_DASHBOARD_PG, which indicates the page within the dashboard
• PRESENTATION_NAME, which indicates the name of the Presentation Catalog
• ERROR_TEXT, which contains error messages from backend databases
• RUNAS_USER_NAME, which contains the name of the user being impersonated

These new columns require updating the physical schemas. SQL scripts that upgrade the schemas reside in the $INSTALL\server\Schema directory. To upgrade the schema, run the script for the database that you are using:

• Oracle_alter_nq_acct.sql
• DB2_alter_nq_acct.sql
• SQLServer_alter_nq_acct.sql
• Teradata_alter_nq_acct.sql

The directory $OracleBI_HOME/server/Sample/Usage Tracking contains the following to help you understand and use the new usage tracking features in Oracle BI Infrastructure 10.1.3.2:

• SQL_Server_Time, scripts for populating sample tables
• Usage Tracking, a new Presentation Catalog for the Oracle BI Infrastructure 10.1.3.2 Usage Tracking features
• UsageTracking.rpd, a new repository file for the Oracle BI Infrastructure 10.1.3.2 Usage Tracking features

For information about merging Presentation Catalogs, see the Oracle Business Intelligence Presentation Services Administration Guide. For information about merging repository (.rpd) files, see the Oracle Business Intelligence Server Administration Guide.