Now we understand the structure of the Auditing DB we can start to use the data. SAP Business Objects supplies a sample universe and some sample reports based on this universe. We won’t be using these samples as they were designed to answer specific questions and so are over complex for this discussion.
With the knowledge we have of the schema we can quickly build a universe. I have attached an example universe. Using this we can build some queries to understand the audit data. This isn’t a blog on either universe design, or report building techniques, so there will be nothing too complex covered, only a couple of simple examples in this post. If you want to use the universe you will need to ensure that it is connected to your audit DB and that you have refreshed the structure to ensure it is mapping correctly to your tables.
Using this universe you should be able to quickly see how the data is structured and the events are generated. A simple query for example can list all the logons to the system.
A little formatting will give us the events and their details.
Another example will return my top users based on the number of times they have logged into my system.
You should be able to use this universe to understand the audit data and to produce some useful reports. Suggestions for enhancements or feedback are always welcome.