Report Usage Statistics

Report Usage Statistics allows administrators to analyse report performance and usage. Each time a Reports Wand report is executed or a Run Report function is refreshed, a record will be inserted into the report usage statistics database table. See the pages below for more information on how to configure, manage and report on this feature.

• Configure
• Manage (database table)
• Report

Configure

Two steps are required for Report Usage Statistics to work with Report Wand.

Install database objects

A database table is used to store the report usage statistics. A database sequence is used to automatically increment and uniquely identify each record. If the database objects have not been created from the initial installation of Wands for Oracle, then the script below can used.

You can modify the script to change the ownership of the table. If you choose to do so, ensure the APPS database user has SELECT, UPDATE and DELETE privileges on the table and create the required synonym to allow the APPS user to access the table without having to fully qualify the table name using the table owner.

APPS.XXE4A_USAGE_STATS
CREATE TABLE APPS.XXE4A_USAGE_STATS (
usage_stat_id NUMBER NOT NULL,
user_id NUMBER(15) NOT NULL,
concurrent_program_name VARCHAR(30) NOT NULL,
responsibility_id NUMBER(15) NOT NULL,
resp_application_id NUMBER(15) NOT NULL,
start_time DATE,
end_time DATE,
row_count NUMBER,
column_count NUMBER,
bind_variables VARCHAR2(2000),
CONSTRAINT xxe4a_usage_stats_pk PRIMARY KEY ( usage_stat_id ));
/
APPS.XXE4A_USAGE_STATS_SEQ

CREATE SEQUENCE APPS.XXE4A_USAGE_STATS_SEQ START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE;
/


Enable Report Usage Statistics

Enable the Report Usage Statistics configuration option under the Reports Wand section of the Wands Administrator Options dialog.

Manage

Reports Wand Administrators can manage the amount of report usage statistics that have been collected by deleting all the existing records in the database table or by deleting the oldest statistics that are not longer required.

Tools > Other > Manage Report Usage Statistics

Delete all records, will delete all records in the Report Usage Statistics database table. Once deleted, they can not be retrieved.

Delete the oldest records, allows the user to delete the a certain number of old records, so that older, new statistics will still exist.

Report

Download the E4A Report Usage Statistics report definition and report template so that you can easily report on the report usage statistics.

A list of sample reports is provided below. For an updated list of reports and the actual report definitions please login to Customer Support Community and search for “Oracle Reports Wand Report Usage Statistics” (include quotes) to locate the article with a link to the files.