Buy

Buy

List of Posts

Get this widget
To get notifications, Please like our Facebook Page >>>>>>

Use Search box to find a topic in this Blog!!!

No. of times a BEx report executed by a User

Posted by Sriramvijay R

If you want a report for No. of times a BEx report executed by a User? Then here is a way to do that.

Our BW systems may have many reports. After sometime some reports lose their importance but it remains in system unnecessarily. To figure out those queries there is a work around. It’s better to create a Report for no. of times a BEx report executed by a user in a period of time. In this blog I am showing how to bring such information into BW reports.
All the Query execution information resides in the table RSDDSTAT_OLAP. Below is the snapshot of the table contents.

Table Contents

The important Fields in this table are,
HANDLETP, UNAME, CALDAY, UTIME, INFOPROV, OBJNAME, STARTTIME.
A generic data source can be created on top of this Table. Where HANDLETP is equal to OLAP for all the BW query execution, so we can restrict our info package selection as HANDLETP=OLAP. STARTTIME is the time stamp of query start time which can be used as generic delta pointer. Other fields can be interpreted as follows,
UNAME = User name, CALDAY = Day on which query executed, UTIME = Time at which query executed, INFOPROV = Infoprovider on which report was created, OBJNAME = Technical name of the Query/report.
This data source can be replicated to BW system and necessary dataflow can be created to store the data in an Infoprovider.

Tips: Add a field ZCOUNTER to Infoprovider and while creating the transformation set this field to constant transformation “1”. This counter can be used for calculating the no. of times a report executed by a user in a specified time( Summation of COUNTER). By adding other characteristics like CALDAY, UTIME in free characteristics it is possible to have various drill downs.

2 comments:

  1. Hay thanks for the share. this helped me in different ways! Sap BO Online Training

    ReplyDelete

  2. Great Information admin thanks For Your Information and Any body wants
    learn SAS through Online for Details Please go through the LinkSAS(Statistical Analysis System) Online Training 

    ReplyDelete

Note

This blog is solely for the purpose of getting educated in SAP. This blog does not encourage distribution of SAP hold copyright and any other publication and/or materials bearing SAP mark. If you find any copyright materials, please mail me so I can remove them. This blog is not in association with SAP.

ALL Posts

Get this widget