Show Menu
TOPICS×

Dynamically Generating Reports

You can generate reports dynamically for the dimension elements that you specify in a lookup file or for a particular number of the dimension elements, such as for the users with the 10 highest order counts.
Adobe discourages the creation of dynamic report sets for daily (or more frequent) report generation. Dynamic report generation can be resource-intensive if you configure reports with large or complex queries.

Lookup File Dimension Element Reports

To configure a report set to dynamically generate and (optionally) distribute reports for the elements of a dimension specified in a lookup file, specify the following parameters in the Report.cfg file:
  • Dimension Name
  • Lookup File
For detailed descriptions of these parameters, see Report.cfg Parameters .
To create a dynamic report set using a lookup file
  1. Create a two-column lookup file for a given dimension. This file must contain two tab-delimited columns, without a header row.
    • Column 1 should contain a list of dimension elements.
    • Column 2 should contain the email addresses of the report recipients. A report for a given element in column 1 is sent to the email address(es) on the same row in column 2. You can enter multiple email addresses by separating them with commas (no spaces).
      • If reports are not to be emailed, column 2 can be empty but must exist.
      • This file may contain blank lines.
  2. Optional. To enable the emailing of reports, you must do the following in the Mail Report section of the Report.cfg file for that particular report set:
    • In the SMTP Server parameter, list the appropriate SMTP server to be used to distribute reports via email.
    • In the Recipients parameter, list at least one email address to enable the reports to be distributed via email. The reports are not mailed to the address listed—you set this parameter only to allow the reports to be emailed. This can be a bogus address, but it must be in an allowable format (for example, jsmith@company.com).
  3. Save the lookup file to the report set’s folder.
  4. Open the Report.cfg file for the report set.
  5. In the Dimension Name parameter, type the name of the dimension for which you want to dynamically generate a report.
  6. In the Lookup File parameter, type the location and name of the lookup file containing the dimension elements that you want in the report and the recipient email addresses.
  7. Repeat these steps for additional report sets.
Dynamic reports are not emailed to recipients until the entire report set is complete.

Top Dimension Element Reports

To configure a report set to dynamically generate reports for the top dimension elements, counting by the specified metric, specify the following parameters in the Report.cfg file:
  • Dimension Name
  • Top N Metric
  • Top N Value
  • (Optional) Preload Query Filter
For detailed descriptions of these parameters, see Report.cfg Parameters .
To create a dynamic report set for the top elements
  1. Open the report set’s Report.cfg file.
  2. In the Dimension Name parameter, type the name of the dimension for which you want to dynamically generate a report set.
  3. In the Top N Metric parameter, type the name of the metric by which you want to sort the dimension.
  4. In the Top N Value parameter, type the number of dimension elements that you want in the report set.
  5. (Optional) In the Preload Query Filter parameter, type the name of the desired filter.
  6. Repeat these steps for additional report sets.
  7. For information about using a dynamic title visualization with your report, see the Data Workbench User Guide .