BusinessObjects Board

Differentiate Between Universe and Excel File Data Source from Audit Database

I have a report that lists out the universes and how many times a report has been run against them. The report now included Excel files since some of our users are using those.

I have a the following filter in the query:

dbo.ADS_EVENT_DETAIL.Event_Detail_Type_ID = 14

How can I differentiate between what is a universe and what is an Excel file?
I don’t mind that they are both coming up on the report but I would like to separate the two.

I don’t have access to an audit database at the moment, but I do remember this document as being a good starting point:

We’ve written our own universe over the Audit database but I will take a look at the one provided by Business Objects to see if it has any ideas.

1 Like