General OBIEE

Get Involved. Join the Conversation.

Topic

    Vishal Gala
    Need a SQL query to list all the scheduled OTBI Analsis and...
    Topic posted July 22, 2019 by Vishal GalaBlue Ribbon: 750+ Points, last edited July 22, 2019, tagged OTBI 
    64 Views, 1 Comment
    Title:
    Need a SQL query to list all the scheduled OTBI Analsis and dashboards
    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..

    Comment

     

    • Tom Strudley
      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