BI 4 - Scheduled Reports Audit

[Former Member]

I'm working with SAP business Objects 4.0

Database type: Oracle

Requirement: Insert a row in a database table, every time a scheduled report runs successfully/unsuccessfully.

I want to store daily updates/status of reports that ran, in a db table.

I have explored Query Builder & Audit universe options with not much luck.

Through Query Builder, even if we get this info somehow, it's hard to export it into db.

Through Audit universe: I'm not able to see all the information through the available objects. I cannot use the canned reports (crystal format) because it doesn't work with oracle database.

If anyone can give any direction to this, I will greatly appreciate.

Thanks in advance!

[Former Member · Accepted solution]

I was able to resolve this using the Activity (audit) universe.

I created a webi report with the following objects in query:

-object name,

-event type = 'Run',

-Folder Path,

-Event Starttime,

-Event status -successful/failed

From Webi, user can extract the query and run directly in Audit database.

A procedure can be used to use this info and feed it into a table.

[Former Member]

Hi Hunain,

Based what I've understood of your requirement, you could look into using EVENT triggers.

Set an event to execute a BATCH file (or an executable which has instructions to write to the Oracle DB).

This event will be triggered based on a report activity.

Regards,

Sid

[former_member182521]

try with the beloww pre-packed audit reports.

Jobs – by Duration	Job events (‘run’ and ‘deliver’) listed by duration in descending order (based on the specified date range and folder path).
Jobs – by Status	Bar chart summarizing jobs by status based on the specified date range and folder path.
Jobs – Failed	Failed job events and event details listed by date based on the specified date range and folder path.
Jobs - Successful	Successful job events listed by date based on the specified date range and folder path.

[Former Member]

pre-packed audit reports don't work on oracle.

What I did is to use the same objects that were used in those reports, and try to create a report with webi using audit universe.

I do see some results. But it only shows the reports/events that were successful. There are no records that show the event_status: failed. I even tried having filter: event_status=failed -- no data.

Secondly, it only works when you have 'this month' as a filter only. If you try to see reports that ran today or yesterday, it gives 'no data to retrieve'.

But this does help though to some extent.

thanks.

[former_member182521]

Please check here http://www.forumtopics.com/busobj/viewtopic.php?t=111635

Modify the cod eto suit to BI 4.0 as well.

[Former Member]

Excel macros won't help

I want to insert a row into a database table every time a report runs/fails.

I was wondering if i can get to the source of Audit tables where this info is stored, but it's not that easy.

PS: Through audit universe, I'm not able to see all the reports that ran. Only few reports with events that were successful.

[former_member182521]

How about your scheduled reports (time driven/event driven)?

How are you capturing your scheduled report status now?

[TammyPowlas]

Hunain - I moved this to the BI Platform space for faster response

[Former Member]

ok -- Thanks Tammy

[former_member185603]

We used SDK to capture all the failed instances and writes to DB table. Explore SDK option.

[Former Member]

It'll be helpful if you can provide few details on how to approach this requirement using SDK

--any documentation or note i can look through?