You can dynamically configure report templates on the Report Template Management page. Data Quality can generate and send reports based on a report template as scheduled.

Prerequisites

DataWorks Enterprise Edition or a more advanced edition is activated so that you can use the report template management feature.

Create a report template

  1. Log on to the DataWorks console.
  2. In the left-side navigation pane, click Workspaces.
  3. In the top navigation bar, select the region where your workspace resides. On the Workspaces page, find your workspace and click DataStudio in the Actions column.
  4. On the DataStudio page, click the More icon icon in the upper-left corner and choose All Products > Data governance > Data Quality.
  5. In the left-side navigation pane, choose Configuration > Report Template Management.
  6. Click Create Report Template.
  7. On the Create Report Template page, configure the parameters.
    SectionParameterDescription
    Basic SettingsNameThe name of the report template.
    Sending CycleValid values: Every Day, Every Week, Every Month, and Do Not Send.

    If you select Every Week or Every Month, you must specify the specific day.

    TimespanThe number of days that have elapsed before the current day. The maximum value of this parameter is 30.
    Statistics of Rule Configuration

    You can select metrics based on your business requirements.

    Offline dataOffline monitoring coverage indicates the ratio of tables that are configured with data quality monitoring rules to all tables in a workspace. The metrics include Table count, Partition expression count, Count of rule on offline data, and Rule coverage on tables.
    Statistics of Rule Execution

    You can select metrics based on your business requirements. Quality reports display the selected metrics in charts.

    Offline dataThe metrics are classified into the following types: About rules, About partitions, and About tables.
    SubscriptionsNotification MethodDataWorks sends report notifications to subscribers by using emails.
    RecipientThe recipient of report notifications. You can add multiple recipients.
    ActionsYou can modify or delete subscriptions that you have added.
    Add SubscriptionClick Add Subscription and configure a subscription.
  8. Click Save in the upper-right corner. A template of data quality reports is generated.
    You can also perform the following operations:
    • Click Preview in the upper-right corner to view the display format of the report template.
      Note If report subscribers view reports in emails, they can view the reports only in tables. If report subscribers view reports on the Data Quality page, they can view the reports in tables or charts.
    • Click Cancel in the upper-right corner. In the Confirm message, click OK to cancel the creation of the report template.

Manage a report template

After a report template is created, the Report Template Management page appears. On this page, you can view the details of the report template. You can also perform the following operations:
  • Find the required report template and click Edit. On the Edit Report Template page, modify the report template.
  • Find the required report template and click Delete. In the Confirm message, click OK to delete the report template.
  • Find the required report template and click View Report. Set the Query Range parameter and view related reports.
  • Add, modify, and delete subscriptions.
    • Add a subscription.
      1. Find the required report template and click Manage Subscriptions.
      2. In the Subscriptions dialog box, click Add Subscription.
      3. Select the required recipient and click Save.
      4. Click OK.
    • Modify a subscription.
      1. Find the required report template and click Manage Subscriptions.
      2. In the Subscriptions dialog box, find the required subscription and click Modify.
      3. Select the required recipient and click Save.
      4. Click OK.
    • Delete a subscription.
      1. Find the required report template and click Manage Subscriptions.
      2. In the Subscriptions dialog box, find the required subscription and click Delete.