Skip to Content

Learning BI 4.2 Audit datase, can't find Universe

Jun 19, 2017 at 02:44 PM


avatar image

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!

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Best Answer
William Peck 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!

10 |10000 characters needed characters left characters exceeded
Manikandan Elumalai Jun 19, 2017 at 03:58 PM

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

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



10 |10000 characters needed characters left characters exceeded
Shreejith Nair 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 http



10 |10000 characters needed characters left characters exceeded
William Peck 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.

10 |10000 characters needed characters left characters exceeded