Setting up multiple reporting schedules for different time periods within the same day. — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood: Oracle Cloud SCM and Purchasing

Setting up multiple reporting schedules for different time periods within the same day.

edited May 26, 2020 11:32PM in Reporting & Analytics for B2C Service 6 comments

Summary

Unable to change VRL_HARD limit, needing a workaround.

Content

Hi,

I need to craft several reporting workarounds to report on previous days data via scheduled runs.

Currently, I have many reports exceeding the 10K limit and therefore are needing to be run manually. I wish to create a workaround of having different schedules report back on different time periods for the previous day, ideally around 3 hours apart.

Example, 6am-9am, 9am-12pm, 12pm-3pm etc.

Could someone please provide the best date_created scheduled filter values to construct the above?

Currently, to report on a previous days full data, we used Date Created = -1 day rounded to 0 days rounded.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!