Oracle Transactional Business Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

203
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

  • Tom Strudley
    Tom Strudley Rank 4 - Community Specialist

    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

  • Akshay Aiyer
    Akshay Aiyer Rank 1 - Community Starter

    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