From where we can get schedule information in audit universe

[nniravv]

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.

[pavan_k11]

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.

[nniravv]

Hi Pavan,

We need this information in webI reports via universe. We need to have objects in universe which customers can further use in reporting. Is there any way to get this done at universe.

[pavan_k11]

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.

[JYOUSAF]

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