Skip to Content
0

From where we can get schedule information in audit universe

Apr 26, 2017 at 12:21 PM

62

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

avatar image
Former Member Apr 26, 2017 at 12:36 PM
1

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.

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

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.

0
Former Member

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.

0
avatar image
Former Member Sep 16, 2017 at 11:04 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded