Skip to Content

Learning BI 4.2 Audit datase, can't find Universe

I am trying to re-build some XI Custom Audit reports in BI 4.2. I'm close but not quite understanding the Universe.

My goal is to simply gauge Usage - by User and by Universe.

For User usage in XI, I mainly used "Document Refreshed" or "Document Retrieved" (which is the "Event Name"), I used that to good effect to give me helpful data on user activity.

In 4.2, here are "Event Types" for five key users, for the 4 months we've been live with 4.2. This seems to be the data I'm looking for to gauge usage.

So I'm thinking in terms of straight activity, I should just count everything, and if I need to refine that, create separate report tabs.
- Thoughts on tracking usage?

.The next main question is that I don't see "Universes" as an object. In XI, Universe Name was in the folder "Action Details", but I don't see anything close in 4.2.
- I want to know which Universes are being accessed by the users. I tried several objects to no avail, but I did find the object "Event Detail Type" in folder "Event Details", but the value is "Universe Name" --- which I don't understand. I'm looking for an *object* Universe Name that has, well, the names of the Universes!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Jun 20, 2017 at 12:43 PM

    so I found the answer via BOBJ forum: I had found the object "Event Detail Type = "Universe Name", but then I needed to look at "Event Detail Value", which tells me the name of the Universe!

    I'll look at the link for some additional resources, but I found my answer!

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 19, 2017 at 03:58 PM

    I would suggest you to go for this instead of building it from scratch.

    https://blogs.sap.com/2015/07/15/unlock-the-auditing-database-with-a-new-universe-and-web-intelligence-documents-for-bi41/

    especially these

    10. SYS2 – System – Delay in Recording of events to Audit Database.wid

    12. SYS3 x1 – System – Overall System Load Analysis (without Mode).wid

    SYS4 x1 – System – Refresh Analysis (Mode is Interactive).wid

    13. USA1 x1 – Usage – Session Analysis.wid

    16. USA4 – Usage – Universe Objects usage. Identify infrequent used objects.wid

    Thanks

    Mani

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 19, 2017 at 10:05 PM

    Hi William,

    Since BI 4.0, sample Auditing report and universe do not come with the install.

    You can get the sample Audit Universe at httphttp://scn.sap.com/docs/DOC-6175http://scn.sap.com/docs/DOC-6175://scn.sap.com/docs/DOC-6175

    Regards,

    Shreejith

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 19, 2017 at 07:19 PM

    So I really appreciate that link, I think I did see it before but didn't review carefully.

    I have everything I need for a custom report except for an object that displays the Universe. Is that not readily available?

    But I will dig into the link, thanks again.

    Add comment
    10|10000 characters needed characters exceeded