BusinessObjects Board

Webi reports viewed by users

other Auditor
#1

I have a report called Webi reports viewed by users and it is for auditing/usage purposes, going off of the activity universe. It seems to do ok for the most part, but when I did a report that queried 1/1/2014 - 1/1/2017, I only got 1/1/2014 - 9/1/2015. Is there a month restriction? I can’t imagine so. I have attached the where clause excluding the joins

DERIVED_DOCUMENTOPERATION_NAME.Object_Type IN ( ‘Web Intelligence’ )
AND
EVENT_TYPE.Event_Type_Description IN ( ‘Document Retrieved’ )
AND
AUDIT_EVENT.Start_Timestamp BETWEEN ‘01-01-2014 00:00:00’ AND ‘01-01-2017 00:00:00’

I can query 7/1/2016 - 1/1/2017 just fine as well, so maybe it’s just a data limit?

giljunie (BOB member since 2017-02-14)

#2

Out of curiosity, when you run the report, do you by any chance see a little yellow triangle in the bottom corner of the report?
If you do, you have a row limit restriction on your Audit universe. You may find that this is set to a default of around 5000 rows.
If this is set, change the setting in the universe to be the amount.

plessiusa :netherlands: (BOB member since 2004-03-22)