Skip to Content
avatar image
Former Member

From where we can get schedule information in audit universe

Apr 26, 2017 at 12:21 PM | 89 Views

Hi

Environment: SAP BO 4.1

We need to have an information about report schedule like what is the schedule type, destination to which it has been scheduled, if schedule type is Email then who all users are receiving mails etc in webI report. We are not able to find any such related objects in Audit universe for same. We have searched SAP forums but no luck.

Thanks in advance.

SAP BusinessObjects - Semantic Layer
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Pavan Kumar
    Apr 26, 2017 at 12:36 PM

    Hi,

    You could you use query builder for this information.

    Link:

    http://servername:portno/AdminTools

    Query:

    Select * from ci_infoobjects where si_kind='webi'

    This will give you top 100 webi reports and its metadeta.

    Initially query one webi report and then choose fields you want in your query.

    select * from ci_infoobjects where si_name= 'reportname'

    You could then export the output to excel.

    Use "TOP" in sql to retrieve more records.

    Add comment
    10|10000 characters needed characters exceeded

    • Pavan Kumar
      Apr 27, 2017 at 02:02 PM

      I haven't explored auditing universe however you could create script using BO SDK's and retrieve the data you require and export them to excel.

      You could then use that excel for reporting.

      OR

      Try exploring audit DB rather than already build universe and that shall answer your questions

      OR

      Instance manager is another option to check all schedules however you can't do reporting on it.

  • avatar image
    AJ Y
    Sep 16, 2017 at 11:04 PM

    This information can be retrieved from either the query builder or by turning on auditing.

    Add comment
    10|10000 characters needed characters exceeded