Data Warehouse request general settings
There are various configuration options available when creating a Data Warehouse request. The following information describes how to configure general settings for the request.
For information about how to begin creating a request, as well as links to other important configuration options, see Create a Data Warehouse request.
To configure general settings for a Data Warehouse request:
-
Begin creating a Data Warehouse request in ÃÛ¶¹ÊÓƵ Analytics by selecting Tools > Data Warehouse > Add.
For additional details, see Create a Data Warehouse request.
-
On the New Data Warehouse request page, select the General settings tab.
-
Complete the following fields:
table 0-row-2 1-row-2 2-row-2 3-row-2 4-row-2 layout-auto Option Function Request name This name appears on the main Data Warehouse page when managing requests. Date ranges Select the date range to be included in the report.
You can choose custom dates, or a preset date range. Preset ranges are relative to the date the report is sent.
The following preset options are available:
- Today
- Yesterday
- Last 7 days
- Last 30 days
- This week
- Last week
- Last 2 weeks
- Last 3 weeks
- Last 4 weeks
- This month
- Last month
- Last hour
Granularity The time granularity. Valid values are None, Hour, Day, Week, Month, Quarter, and Year.
Reporting granularity requires additional processing time. If you are reporting monthly granularity for an entire year, your reports process much faster if you submit a report request for each month.
Note: When applying granularity in a Data Warehouse request, the ‘Date’ column is added to the report. Depending on the granularity selected, the date format changes, as follows:
-
Hourly granularity:
- Format:
mmmm d, yyyy
HourH
- Example: January 1, 20XX, Hour 0
- Format:
-
Daily granularity:
- Format:
mmmm d, yyyy
- Example: January 1, 20XX
- Format:
-
Weekly granularity:
- Format: Week
w, yyyy
- Example: Week 1, 20XX
- Format: Week
-
Monthly granularity:
- Format:
mmmm yyyy
- Example: January 20XX
- Format:
-
Quarterly granularity:
- Format:
q
Quarteryyyy
- Example: 1st Quarter 20XX
- Format:
-
Yearly granularity:
- Format:
yyyy
- Example: 20XX
- Format:
Make available to users in your organization All data warehouse requests are visible only to you and any system administrators. Enable this option if you want to make the request visible to everyone in your organization.
Enabling this option is useful if you want other users in your organization to help create or update the request.
-
Continue configuring your Data Warehouse request on the Build your report tab. For more information, see Build a report for a Data Warehouse request.