Webi Scheduling report

[former_member648413]

Hi Everyone,

I have a question on scheduling a BOBJ report.

I have three columns, Selling Month, Selling month Start date and End date.

I would need to schedule a report every month so it picks the whole selling month correctly. It is not the actual month 1st and 30/31st.

Example: January 2021- It can start on Jan 1st 2021 and end on Feb 2nd 2021. So the schedule should automatically pick it up.

Within BO, I know we can run Daily, Monthly based on a specific date. I am exactly not sure on how to schedule this type of a report. Help is greatly appreciated.

Thanks,

Amritha.

[amitrathi239]

You need to create Start Date and End Date objects in the universe to capture the 1st Jan and 2nd Feb. Always this objects should show the month start date and end date values only.After that use these objects in the webi query instead of prompt conditions.

With this solution you can simply set the up the monthly schedule so that report run with latest data.

Other option is if this is monthly report than you can create 12 difference schedule instance (for one year) for each month and report instance will run accordingly.

[former_member648413]

Hi Amit,

We already have Sales month begin date and end date.

"Other option is if this is monthly report than you can create 12 difference schedule instance (for one year) for each month and report instance will run accordingly"?

Can you help me understand on How 12 difference schedule instance for one year for each month is implemented in BO Webi ? Is it by Admins ? Goal is to run on a sales month begin date of next month so it picks up this period- Start date - 05/01/2021 - End date 02/01/2021 previous month.

For Jan 2021 Selling Month - Start date - 05/01/2021 - End date 02/01/2021. Every Month it should run on End date +1 i.e. 2nd February 2021 which is the begin date of Feb 2021 to pick up the previous month.

Thanks,