Learning BI 4.2 Audit datase, can't find Universe

[former_member392074]

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!

[former_member392074 · Accepted solution]

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!

[former_member182521]

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-intelligen...

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

[former_member209323]

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

[former_member392074]

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.