Period
Business metrics are often calculated for specific time ranges, such as "the last 7 days" or "the current calendar month". To standardize these calculations and improve efficiency, create reusable periods. You can then use these periods when configuring derived metrics.
Overview
A period, an atomic metric, and one or more modifiers form a derived metric, which reflects the status of a business activity. For more information about derived metrics, see Derived metrics.
Create a period
Go to Data Modeling.
Log on to the DataWorks console. In the top navigation bar, select the desired region. In the left-side navigation pane, choose . On the page that appears, select the desired workspace from the drop-down list and click Go to Data Modeling.
On the Data Modeling page, in the top navigation bar, click Data Metrics. In the left-side navigation pane, click Period.
Create and configure a period.
Click the
icon to create a fine-grained period.DataWorks provides nine built-in period granularities, such as Day, Week, and Month. You can use these granularities to create more specific periods, such as "last day" or "last three weeks".
Configure the Basic Information for the period.
The following table describes the basic parameters of the period.
Parameter
Description
Period Granularity
The base time unit to which the period belongs.
Abbreviation
The unique abbreviation for the period. This value cannot be changed after creation.
Name
The name of the period.
Display Name
The display name of the period.
Owner
The user who owns the period. Defaults to the user who creates it.
Description
The description of the period.
Click Save and then click Submit. After you submit the period, you can reference it when creating derived metrics.
You can reference submitted periods in derived metrics. If a period is already in use, you must remove the references before deleting it.
Import periods
Use the batch import feature to efficiently create multiple periods.
On the Period page, hover over the
icon and click Import from Excel. In the dialog box that appears, download the template file.Enter the information for the periods into the template. Follow the column descriptions and examples provided in the template.
Return to the import dialog box and upload the completed template. Set Import Type to Period and start the import. For more information about the process, see Batch import.
Next steps
You can use the modifiers, atomic metrics, and periods that you create to configure derived metrics. A derived metric calculates the value of an atomic metric within a specific period, dimension, and business condition. For more information about how to reference a period in a derived metric, see Derived metrics.