Differentiate Between Universe and Excel File Data Source from Audit Database

[JohnBClark]

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.

[MarkP]

I don’t have access to an audit database at the moment, but I do remember this document as being a good starting point: https://www.speakbo.com/wp-content/uploads/2018/03/Speak-BO-Understanding-the-Audit-Database-in-SAP-BI-4-Slides.pdf

[JohnBClark]

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.