Configure report options for a Data Warehouse request

Last update: 2023-12-21
  • Created for:
  • User
    Admin

There are various configuration options available when creating a Data Warehouse request. The following information describes how to configure report options 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 report options for a Data Warehouse request:

  1. Begin creating a request in Adobe Analytics by selecting Tools > Data Warehouse > Add.

    For additional details, see Create a Data Warehouse request.

  2. On the New Data Warehouse request page, select the Report options tab.

    Report destination tab

  3. Complete the following fields:

    Option Function
    File name Identifies the report.

    If any of the following special characters are used in the file name, the request cannot be saved: ! " # $ & ’ ( ) * + , / : ; > = < ? @ [ ] \ ^ ` { } | ~

    The % character can be used only if it is followed by “R”, “rsid”, or “id”, as follows: %R, %rsid, and %id.

    Append report date range to file name Adds the date range to the report file name.

    For example, if you request data from May 1, 2024 through May 7, 2024, the filename includes the date range of 20240501 - 20240507.

    CSV Delivers reports in a CSV file format for viewing data in a spreadsheet.
    Tableau (TDE) Delivers reports in a Tableau Data Extract (TDE) file format, which can be used to visualize data and layer in additional data within Tableau.
    Send report as compressed file (ZIP) Delivers reports in a compressed (ZIP) file format. We recommend enabling this option when using email as the report destination.
    Return all rows When enabled, all rows are included in the report. Disable this option to specify the number of rows to include.
    Beginning of report comments Add any comments that you want to be included with the report. Comments appear at the beginning of the report.
    Sort by metrics Provides ranked breakdown reports in Data Warehouse, sorted by descending metric value. Sorting by metric makes Data Warehouse reports easier for you to interpret, and makes these reports easier to compare with other Analytics breakdown reporting views.

    For more information, see Sort by metric.

    Send a manifest file Includes metadata about the files included in the report.
    Send a digital signature file Allows report recipients to verify that the file came from Adobe and that it has not been altered.
    Send an empty file when there is not data in the report Sends a report even when the report contains no data.
  4. Continue configuring your Data Warehouse request on the Scheduling options tab. For more information, see Configure scheduling options for a Data Warehouse request.

On this page