Skip to Content

BO 4.2: How to query a Webi report in the Audit

Hello,

We are using Business Objects 4.2. When a user creates a report in Webi, gets the data but doesn't save it,
it seems that the query trace is not stored in the Audit DB or if so, we can not get it through the Audit Universe.

So, the question is: Is this trace data stored in the Audit DB? Is there any way to get this data in the Audit Universe?

Than you very much,

Jose Manuel.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Best Answer
    avatar image
    Former Member
    Dec 16, 2016 at 10:17 AM

    In Audit Database we have one of the table as ADS_EVENT_TYPE_STR. If you query this table you would see different Event Type that gets loaded to Audit DB. In your case I think you are interested in Refresh Event. So for Refresh the Event_Type_ID is 1003. You can further join Audit Event table,Event Detail table and create a query as per your requirement.

    Hope this Helps!!

    Sumit

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 15, 2016 at 07:43 PM

    That action should still generate audit data, although there won't be an object_name or object_folder_path associated with it. If you just look for Refresh actions for the particular user_name, you should find it.

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 15, 2016 at 02:57 PM

    Web trace will not be recorded in Audit.

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 16, 2016 at 08:59 AM

    Hello Joe,

    Thanks for your response. So, you mean we can access this data through the universe we have created to access the Audit database? but looking for a particular user_name?

    regards,

    Jose

    Add comment
    10|10000 characters needed characters exceeded

    • In theory, yes. Easy enough to test -- perform that action with your own ID (i.e., create a report, refresh it, close without saving), then in 10 minutes or so run a report in the Audit universe, querying for your ID as the user_name.

      And just FYI -- you should have posted this as a comment on my answer, rather than as a new answer. I didn't get a notification and only saw your note when I can back to look at the the question. The new SCN is confusion, so it's an easy mistake to make.

  • Dec 19, 2016 at 08:52 AM

    Sumeet, Joe, thank you for your response. I think it will help us.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 26, 2016 at 09:41 AM

    Hi Jose,

    Please let us know if you get the data in Audit.

    Normally, Object id is generated when we save the object (report). 'create' event can be recorded with user objects but not sure how the 'refresh' event is recorded without report object.. thanks!!!

    Add comment
    10|10000 characters needed characters exceeded