Skip to Content
0
Former Member
May 30, 2008 at 03:50 PM

Automated reporting on dataloads for end-users

24 Views

Dear forumers,

we are on BI 70

we are looking for a way to provide our endusers with a report/query, whichs shows the status of dataloads in each cube.

On forums I have found some tips on using the table RSREQDONE. Based on requests in this table, one should be able to provide a list with the number of records, start/stop times. When you create an infoSetQuery on this, it can give you some data.

But we load based on Process Chains, and we want to show the success or failure of each process chain, and show the date/time when this was completed. And we use DTP's for some of our loads, so no InfoPackages overall.

BTW: the technical status in a query on a multiProvider is not very helpfull, as this only shows the oldest data load from all underlying infoproviders; when one is a History cube which is updated once in the past, no usefull data here shown...

has someone looked into this as well? does someone have some tips, advice pointers for getting such a end-user usable query on data status?

-Jaap