Oracle Transactional Business Intelligence

Products Banner

Need a SQL query to list all the scheduled OTBI Analsis and dashboards

127
Views
2
Comments

Summary

We need to review and track all the OTBI reports that are scheduled via agents

Content

Having the ability to query this out helps us understand who all have scheduled the reports other wise there is no easy way for the administrator to know..

Tagged:

Comments

  • Hi Vishal

    Have you checked the logs in OBIEE Administration>Manage Sessions or Administration>Manage Agent Sessions

    It's not pretty but will show you analyses run and gives you some sort and filter options. Be careful though as you can clear the cache

    Thanks
    Tom

  • Hi Vishal!

    May I know how have you attained the resolution for this query of yours?

    Our business here also wants to keep track of all the BI Scheduled Reports with the timings and the recipients. With the list being long we also are trying to figure out a SQL query or a way to get it but unable to.

     

    Thanks,

    Akshay