Skip to Content

How to find expiration date of reports in Public Folders in Business Objects

Hello All,

How to find expiration date of reports ( Webi and Crystal) in Public Folders in Business Objects. We are having many reports developed years back and those are getting failed due to expiration of end date when it is scheduled to run. So wanted to check if we can get the expiration date of all reports and analyze the end date of the report and modify it to future date so we dont get frequent failures.

Thanks,

Kavin

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Nov 16, 2017 at 04:48 PM

    You can find the report schedule exipre date in the Instance manager in CMC.Select the option to find out all recurring jobs and then you can check the schedule exipre date.

    Add comment
    10|10000 characters needed characters exceeded

    • Thanks Amit. This works for the reports scheduled in BO itself.

      But we instead use Autosys tool to run our reports based on the dependency of Reporting data completion. Is there any query we can retrive it from Query Builder.

  • Nov 17, 2017 at 06:28 AM

    Hi Raj,

    Use the below sample query from query builder, this will retrieve schedule info such start time and end time and recurring type.

    also you can use recurring type in where clause, that gives schedule info (start time and end time) of all the recurring instances.

    SELECT SI_SCHEDULEINFO.SI_STARTTIME,SI_SCHEDULEINFO.SI_ENDTIME,SI_UISTATUS, SI_RECURRING FROM CI_INFOOBJECTS WHERE SI_INSTANCE=1 and <SI_KIND=report type>

    Thanks

    Ashraf

    Add comment
    10|10000 characters needed characters exceeded