Categories
- All Categories
- 75 Oracle Analytics News
- 7 Oracle Analytics Videos
- 14K Oracle Analytics Forums
- 5.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 40 Oracle Analytics Trainings
- 59 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Data Visualizations Challenge
- 3 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
Need functionality to schedule BI reports with Bi-weekly or every 2 weeks option
Description
Current functionality does not allow bi-weekly option.
Use Case and Business Need
Currently we can only schedule any BI reports with daily, hourly, weekly, monthly, Annually and specific dates. There is no way to schedule biweekly. We are using custom dates for bi-weekly option but it would simplify if we can select every 2 weeks option.
Original Idea Number: c43469eadd
Comments
-
Hi,
We have a similar requirement for our HCM to Payroll integration wherein we want to run the extracts
1. Exclude Monday and Tuesday
2. Exclude 11th, 12th, 13th and 14th of the month.
at the moment the BI reports does not have date exclusion options to meet our requirement. Request the BI reporting team to enhance the scheduling feature to meet custom date options.
Looking forward to have the feature at the earliest
Thanks
Rizwan
0 -
Hi,
We have a similar requirement for our HCM to Payroll integration wherein we want to run the extracts
Exclude Monday and Tuesday
Exclude 11th, 12th, 13th and 14th of the month.
at the moment the BI reports does not have date exclusion options to meet our requirement. Request the BI reporting team to enhance the scheduling feature to meet custom date options.
Looking forward to have the feature at the earliest
Thanks
Rizwan
0 -
Agreed. We need this enhancement at earliest. There should be an option to exclude holidays, non working days etc.
We need to run extracts every 5 business days (Starting from 2nd business day) of each month and exclude holidays falling on weekdays. Currently there is no way to schedule extracts only for calendar days so we have to schedule at least 50 batches manually each month and some times 2 times each month. There should be an option to exclude dates.
0 -
Agreed. We need this enhancement at earliest. There should be an option to exclude holidays, non working days etc.
We need to run extracts every 5 business days (Starting from 2nd business day) of each month and exclude holidays falling on weekdays. Currently there is no way to schedule extracts only for calendar days so we have to schedule at least 50 batches manually each month and some times 2 times each month. There should be an option to exclude dates.
0 -
I can see the value in this - especially where the report is scheduled as an operational or compliance (SOX) control. Would like to see this option added.
0 -
Hi,
This is not possible to achieve if we schedule the reports in Reports and Analytics. However, this can be achieved if you create an ESS job to run the same report. ESS Job can be scheduled on weekly basis. While scheduling you will have the option to select the dates on a weekly basis.
Hope this helps.
0 -
Hi Piyasa,
Currently we are scheduling jobs in Financial Reporting Center\Oracle Workspace not in "Reports and Analytics". Are you saying we can create ESS jobs in Oracle Workspace? I am trying to understand because we use oracle fusion cloud to access FR webstudio for creating financial reports. we don't have license to Essbase or Planning.
Thanks
Priya
0 -
Oracle has recently ‘archived’ a bunch of great ideas because they have not yet got enough votes from the community. Hopefully the community provides more votes to keep this Idea alive.
0 -
Hi Kalpalatha,
Please find below ways to achieve this functionality.
Fusion BIP : How To Schedule BI Publisher Reports On A Biweekly Schedule (Doc ID 2445717.1)
Other way to create a custom ESS job with schedule.
Regards,
Swapnil
0 -
Great idea - This needs Oracle's attention. I would encourage to comment and vote this idea so Oracle does not archive it.
0
