BW Reporting on data load monitor

[former_member669262]

Hi,

I want to create BeX reports on the load monitoring like .....Which data load ODS/Cube objects passed/failed.? How many loads passed/failed in last 1 day/week/month etc.How frequently is a particular ODS/Cube been loaded ?

Has anyone worked on creating Data load monitoring Reports like this ? Is there a BW table where all the above data and details are stored for BW Monitor ?

It would be appreciated if you can let me know.

[Former Member]

Hello ,

BW standard Statistic Objects do not provide you realtime status. So, you can check the link which i have provided here which will give you complete flexibility of monitoring the data load in real time in Bex.

This development is one of my SDN Contribution...! Enjoy SAP

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/64d214d2-0a01-0010-0990-e141be4a...

-Anil Raparthi

[Former Member]

Hello Kishor,

I know of an application that can do this for you and a lot more. Send me an email and I will send you a documentation on this.

mkpume@aol.com

[former_member669262]

Hi Partho,

Thanks for the reply and Info.We have already installed BW Statistics and already querying on it.

One of the link you sent in your reply -

and the reply posted by Pizzaman helps and it is something similiar i am looking to do eg. to get lot of the query statistics from ST03N in Expert mode, e.g. how many times a query ran last week, avg run time, avg nbr of rows selected, etc..

similiarly i want to create queries to check how many times a dataload ran last week,avg run time,data loads sucessfull/failed in 1 week ?.....basically querying on the Status Overview of the data load monitor.

[Former Member]

hi kishor,

I am not sure if this helps you, but try using BW statistics info providers.refer this links..

http://help.sap.com/saphelp_bw30b/helpdata/en/8c/131e3b9f10b904e10000000a114084/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/8c/131e3b9f10b904e10000000a114084/content.htm

hope it helps,

regards,

Parth.