Reporting Statistics Report in SAP BW

In BW Reporting scenarios, business or application manager who deals with the BW reporting requires a report, how many times does the report executed by which user, on what timing, DB time at the time of query execution, frond end time etc. can be determined in a single report. Below are the custom report details,

1. On initial, the BW Administration cockpit is installed as a pre-requisite.

    2.  Create a custom query based on the Multiprovider (0TCT_MC01) which provides data form the Info provider Front-End and OLAP Statistics (Aggregated).    This Multiprovider provide proper information with satisfying the requirement.

Rows:

Calendar Month (0CALMONTH)

Report Name (0TCTBISBOBJ)

User (0TCTUSERNM)

Note: Please chose property Display Result Rows with “Always Suppress”.

Columns:

Number of Executions (0TCTQUCOUNT)

Duration (OLAP) (0TCTTMEOLAP)

Average Duration (OLAP) – Calculated Key Figure (Time OLAP (0TCTTMEOLAP) / Count for BI ApplObj (0TCTQUCOUNT)

Free Characteristics:

Calendar Day (0CALDAY)

Note: If you require at what time the report is executed, please include the filed Time Stamp of Report execution.

         Please chose property Display Result Rows with “Always Suppress”.

Filter:

BI Appl. Obj. Type (0TCTBISOTYP) – Include ELEM (Which Selects Reports only)

Calendar Month (0CALMONTH) – User Entry Variable, which provides selection to the User to select which Month data required

Info Provider (0INFOPROV) – Include Only Info Provider (0TCT_C01)

User (0TCTUSERNM) – User Entry Variable, which provides selection to the User to select which User data required

Report Name (0TCTBISBOBJ) – User Entry Variable, which provides selection to the User to select which Report data required

Object Version (0TCTOBJVERS) – Include Only Active Version (A)

BI System (0TCTSYSID) – Add SAP Exit Variable (0P_SYSID)

3. On successful creation of the query, execute the report and it will displays the below output,

Variable Screen:

Report Output based on the Variable entry selections: