WEBI Documents vs. Scheduled Instances

system · March 23, 2015, 6:01pm

In Activity/Audit universe, is there a way to differentiate refreshes of a WEBI document in InfoView vs. instances created from scheduled refreshes?

We are using 3.1.

Thanks!

jdean1012 (BOB member since 2007-06-26)

system · March 23, 2015, 6:58pm

Yes, but it’s a PItA. You have to look for the existence of a Logon event with the same session ID. If there’s a logon even, then it was an interactive refresh. If there was no logon event, it was a scheduled refresh.

joepeters (BOB member since 2002-08-29)

system · March 23, 2015, 7:03pm

Got it…thanks!

jdean1012 (BOB member since 2007-06-26)

system · October 6, 2016, 9:23am

Hi,
Can you please elaborate on more please or give me sample query? , We are trying to find the active reports for last 6 months but our results are not coming correct due to schedule instances.

sat.dpi (BOB member since 2009-02-12)

system · October 6, 2016, 1:37pm

I created a universe for auditing BusObj and created a derived table that identifies SESSION_ID’s that are associated with a LOGON event in ADS_EVENT:

SELECT DISTINCT
SESSION_ID
FROM MBPBOAUD_USER.ADS_EVENT
WHERE EVENT_TYPE_ID = 1014
AND SESSION_ID IS NOT NULL

Then, I outer joined this derived table back to ADS_EVENT based on SESSION_ID.

Finally, I created an object based on this relationship that basically says that events with the same session ID as the derived table are those where the “User Logged In” and the others are assumed to be “Scheduled.”

CASE WHEN NVL(ADS_EVENT.SESSION_ID,’-1’) = NVL(ADS_EVENT_LOGON_SESSION.SESSION_ID,’-1’) THEN ‘User Logged In’ ELSE ‘Scheduled’ END

This is FAR from perfect, but it at least gives me some direction.

Hope this helps!

jdean1012 (BOB member since 2007-06-26)