Technical Blog Post
BiLog: Got Game? Got Audit Requirements? And want to run reports?
Got Game – Holiday Game? Game
from cheering on the Packers, maximizing your consumption of apple or pumpkin
pie, or Game from braving the crowds on Black Friday? My game came into play last week in a
Lasertron Match with over 40 family members after an incredible Thanksgiving
Day Feast. While my phaser accuracy would cause teammates
to cry for trades, our family had an amazing time in our annual, Buffalo tradition.
As we turn from holidays back to the work week, we change from Got Game to Got Audit Requirements. Many clients have internal and regulatory tracking requirements on their data, and to comply with the requirements, reports are often used.
One of the 150 plus reports delivered with the Version 7 products is the eAudit report. This report details the eAudit Transactions within a given time period for the selected database objects and attributes. However, what makes this report unique is that its sql is dynamic as the user selects any 'Auditable' Version 7 objects and attributes at run time. You can find more details on this report and other Version 7 reports by accessing the Version 7 Report booklets detailed here.
If this delivered report does not meet your unique business
needs for audit compliance, you could quickly create an ad hoc report. To highlight how you can quickly do this,
we’ll imagine you have to deliver a report with audit data in the Asset
application. To recap, when you create an ad hoc report using multiple database objects, you must have a corresponding report object structure (ROS). You can find these described in more detail here.
1. To do this, go to the Database Configuration application and filter on the asset application. In the relationships tab, filter to see if there is a relationship to A_ASSET. In this case, a relationship wasn’t available out of the box, so one was created as shown below.
2. Next, navigate to the Object Structure application to add a new ROS. This ROS will enable you to create audit ad hoc reports from the Asset application, so its parent is ASSET, and the child is A_ASSET. It uses the new relationship created above to join the ASSET and A_ASSET objects together.
4. Now, you can begin building your custom ad hoc report using the new Asset Audit ROS you have created as shown below. You can then save this report, share it with others and also schedule it to execute on a regular basis.
You can find additional details on this example here
The delivered eAudit report and Ad hoc reporting audit capability give you a variety of options to meet your audit requirements.