Skip to Content

SAP BO Report Scheduling - find and remove/delete email recipients from destinations

Hi Experts,

Is there a way how to export a list of scheduled reports from BI platform icluding the scheduled report email destination addresses? Imagine a situation where the employee leaves the company and there are many reports with the following employee's email address.

It would be great to have a solution to find all the reports and change it using code istead of doing it manually. However, let's firstly concentrate on only retrieving a list of report schedules with email destination addresses.

I found several threads online:

What tool are you using to extract and administer the data from nested sets? For e.g.

select *  from ci_infoobjects

Using BO:8080/AdminTools/querybuilder/ie.jsp I am able to retrieve the information in HTML format where I can see the data in nested sets like


However, all this information is available in HTML. Do you have any ideas how to export it in excel format?

I have tried CMS Query Builder application however, instead of the nested sets I have only retrieved the Path of the object.

Do you have any other ideas how to export the list of recipients mails from BI platform in a user friendly way?

P.S. I know about the 3rd party tools already. I have raised this question to look for possible solutions regarding this matter.



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 25, 2017 at 03:08 PM

    Unfortunately you cannot get this information without using 3rd party tools like 360. Since BI 4.2 sp4, SAP offered a universe which can allow to query CMS DB, it is one solution ut of the box. But if you are not BI 4.2 sp4, you are out of luck.

    Or you can use SDK (Java or .net ) to extract this information.

    Add comment
    10|10000 characters needed characters exceeded