Skip to Content
0

I want to know the reports that are executing first of every month in BO Server in excel format

Aug 14, 2017 at 02:33 PM

45

avatar image
Former Member

We are using BOE 4.0. is there any way to know the reports that are executing in BO server on 1st of every month.

Thank You.

10 |10000 characters needed characters left characters exceeded

Hi,

You can try below query in Query Builder

SELECT * FROM CI_INFOOBJECTS WHERE SI_KIND IN (‘FullClient’, ‘Txt’, ‘Excel’, ‘Webi’, ‘Analysis’, ‘Pdf’, ‘Word’, ‘Rtf’, ‘CrystalReport’, ‘Agnostic’) AND SI_KIND = 'Webi'

here are more examples

http://blogs.hexaware.com/business-objects-query-builder-part-ii/

https://blogs.sap.com/2012/10/11/businessobjects-query-builder-queries/

Thanks,

Jothi

1
Former Member
Jyothirmayee A

HI Jothi,

Thanks for the response. i am getting error with query you provided and moreover i need the reports that are executing on 1st of each month.(Ex:1st Aug 2017). Can you help me with the query please?

Thanks in advance

Chan

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
avatar image
Former Member Aug 14, 2017 at 03:27 PM
0

In Instance manager we can see the list of reports that are executing. But i want those list of reports in excel, word or pdf format.

can anyone suggest on this.

Thank You

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

Looks like you figured out the solution to Query builder

If not, try something like this,

SELECT top 100000 * FROM CI_INFOOBJECTS WHERE SI_SCHEDULEINFO.SI_SCHEDULE_INTERVAL_NDAYS = 30

Do you want logs of Instance Manager to export to excel?.

I'm sure it is not available right now. There is workaround, you can try by downloading excel workbook from below link.

http://www.forumtopics.com/busobj/viewtopic.php?t=168709

Thanks,

Jothi

0
Former Member

No I did not get Answer to the question. Could you please give me the query that should give the result of "The reports that are executed on 1st of September 2017?

0