Skip to Content

Query to find all Webi reports that ran over particular period

Hi,

Can anyone please let me know the query to find all Webi reports that are accessed or ran since last year and the name of the universes being used by each report.

I appreciate the help.

Regards,

Kristen

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    May 11 at 05:20 PM

    you cannot use the query builder to get the audit report of who accessed the reports past 6 months. Query builder is for extract the CMS DB information, not AUDIT. What version of Business objects you have? Check below link if you don't have Audit universe.

    https://blogs.sap.com/2015/07/15/unlock-the-auditing-database-with-a-new-universe-and-web-intelligence-documents-for-bi41/

    Add comment
    10|10000 characters needed characters exceeded

  • May 09 at 06:40 PM

    DOn't you have Audit universe to get this.

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Jawahar,

      Thank you for your reply.

      All the default events are enabled, not all events (like Analysis events, Lifecycle management events) as shown below. I need to pull the list of all Webi reports that are accessed in last six months and i'm trying to use query builder. Could you let me know the query or if there's other way to find this info?

      Thanks!

      Kristen

      capture.png (18.8 kB)