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,
- 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.
Calendar Month (0CALMONTH)
Report Name (0TCTBISBOBJ)
Note: Please chose property Display Result Rows with “Always Suppress”.
Number of Executions (0TCTQUCOUNT)
Duration (OLAP) (0TCTTMEOLAP)
Average Duration (OLAP) – Calculated Key Figure (Time OLAP (0TCTTMEOLAP) / Count for BI ApplObj (0TCTQUCOUNT)
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”.
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,
Report Output based on the Variable entry selections: