How to schedule hourly data warehouse request for the same date?

Description

How to create Data warehouse requests with hourly granularity to deliver files on an hourly basis for the current date?

Resolution

Steps to create Data warehouse requests with hourly granularity to deliver files on an hourly basis for the current date;

  1. In Data warehouse UI, go to ‘Data Warehouse request’

2. After selecting Report suite and Request Name, Select preset as ‘Last Hour’ and granularity as ‘Hourly’.

  1. Select the components (segments, dimensions, metrics) you want in the report.

  2. Under Schedule Delivery Advanced Delivery Options  Scheduling Options Schedule for later

  3. Select Delivery frequency as ‘Hourly’, Starting On as the current date, ‘Time of day’ from which hour you want to get hourly data (example: 2 AM) and End delivery date (this should not be of the same day. Never end or any future date example would work).

5. Schedule

6. Enter email for notification Request this report

On this page