In the report itself added a filter to only show web intelligence rows, since that's what we run in our environment. Since the report is run daily and emailed, this is precisely what we wanted.ġ0. Filter on the yesterday6am and today6am to only bring in results for the desired 24 hour time period. We only want to represent a report one time… thus this clause in the report filter.ĩ. since we have all the auditing options turned on each report job will be represented 3 separate times: "Object Folder Path," "Object Name," "User Groups"). = "Object Folder Path" (this shows only the locations of the reports. = 327681 327682 (this represents the statuses of successful and failure)Ĩ. Changed filtering at the Query level as belowħ. I added columns to the result table and did some investigation into key values, etc.
BO uses numeric values that are not meaningful without some digging. It takes a little detective work to figure out what values to filter on. Added Result Objects to the query as necessary. I used sorting and alerters to call attention to failures (as in the below steps).ĥ. I'd rather look on one report than have to switch between two tabs on a Web Intelligence report or an Excel workbook. Merged the failed and successful reports onto one report. This report seems kinda useless unless you plan on having a large percentage of failed reports. Copied the business objects auditor canned report "Jobs Summary" and re-worked. We run in an Oracle environment so these objects were as follows: The relative date objects allow for the rolling twenty four hour reporting period. Created 2 "relative date" objects in the "Activity" universe: Yesterday6AM and Today6AM. You will likely need to do something at least a little different.ġ.
What is the audit number on id mods#
Here's the major high level mods I made to set up the custom report. I tried to get "unmerged" cells in excel… which is usually an exercise in futility… and it was in this case. Excel won't sort cells of uneven widths (merged and not). This can make it difficult to sort in excel without doing some column copy-paste-delete-editing stuff. Unfortunately when BO outputs to Excel it is next to impossible to control where BusinessObjects merges the Excel cells (vertically and horizontally). That way, if anyone wants to sort or manipulate the data further, it will be easier. I set up the report to mail an excel format file. After failures (if any) it will sort by duration in descending order so we can see the longest running reports on top. I set the report to show any report failures at the top of the report, and I've set an alerter to make the entry red and bold. And I created a custom report for our environment. So I made a couple of simple mods to the "Activity" universe (which is what the auditor package runs off of). Here's a list of the canned reports that are packaged with auditor:Ĩ. It turns out that there weren't any canned reports that shipped with auditor that reported in a form that was useful in our environment. I looked through the canned reports that came with XI. Our environment is BusinessObjects XI Release 2 on Linux. Since it reports on 6AM to 6AM it will capture the scheduled report processing which is complete by 6AM.
So I set the report to run daily at 7:00AM. In our environment our heavy hitting reports are all Web Intelligence reports so we wanted to limit reporting to Web Intel and not all jobs (as the default BO report provide). We needed to have report stats monitored and sent out each morning after the heavy processing of the scheduled reports was completed.Īs our reports run early morning, I wanted to set the report period to be 6AM yesterday to 6AM today. Given the timeout limits that are imposed on reports, if they run too long they will fail. One of the primary concerns for one of our clients was the monitoring of report run times. If you use the auditor package in Business Objects XI, you will very likely need to create custom versions of the canned reports to provide metrics that are useful to your specific organization.