Hi BOBJ Gurus,
I am trying to configure Audit database / universe in 4.1 SP2 and have imported .unx universe into IDT so I can run my audit activity report within organization.
I have configured Auditing in the CMC (Plz see Fig1 attached), I have almost selected everything as far as capturing the events are concerned.
I didn't change anything in the universe and published it in the repository and created a webi report accordingly. When I try to run the webi report based on objects like Application Type, Event Type, Event Status, user Name, Object Type etc, I dont see any deleted event type in the report. I am not sure whcih object do i need to capture the delete log.
I even created a sample report and deleted from the system but no log in the report.
I checked the tables in the universe and there are some tables in unx file such as ADS_EVENT_DELETES, ADS_EVENT_DETAIL_DELETES and these tables are not joined with any other table and I also checked but there is no data in these tables. I even joined these tables and set an outer join so atleast i can see if there is any data but these tables are blank.
I am just wondering if these tables are supposed to be empty and Is there any other object that I need to use to capture and delete activity on the BOBJ side.
My question is that How do I go about and see Delete logs/activity in my webi report.
Will appreciate your help.