Introduction

There are innumerous number of Reports which are created (either by implementation team, support team, technical team and also some by business superusers) in an ERP Application. While some of them are used regularly a few of them are only created as the need of the hour and are not referred in future. Such kind of reports (occasionally / one-time use reports) continues to stay in the application cluttering the BI Catalog Area causing confusion and chaos.

As such if there is a mechanism to find out details like:

1. Which Report was run how many times

2. Last date on which a report was executed

3. User who ran the report

Then one may take an informed decision on whether actually a Report is required or can be removed the system.

In order to arrive at such conclusion, there is a need to have a Report which should be able to provide us Report Execution Details. While there does not exist a delivered report at this time one can surely go ahead and create a custom BI Report to meet our needs.

In this article, we will try to create one such report.

We would name this report as “BI Catalog Component Audit Report ”

A high-level overview of how to create such a report is already given in Metalink Note ID 2059102.1

We would try to follow the steps and create a simple report using the details provided.

Creating BI Catalog Component Audit Report

We would configure a BI Data Source as explained in the Metalink article above.

Navigation -> BI Catalog -> Administration-> Manage BI Publisher -> Create JNDI Data Source

Data Source Name – Any name of your choice. BICatalogAudit in this case

*JNDI Name         – jdbc/AuditDB

Allowed Roles     –  BI Consumer Role

Once the BI Data Source is configured we can create a BI Data Model from it.

Notice that we have used a parameter p_reportabsolutepath which has an LOV attached to it. The query for the LOV is :

Once done we may run the Report (once without passing any value to parameter wherein details for all the reports are shown:

And when we pass the Report Name then it displays data for that specific Report Execution only

Ashish Harbhajanka

Add comment