How to create public calendars and tags - Dataphin - Alibaba Cloud Documentation Center

Dataphin provides a tenant-level public calendar feature. This feature allows you to create custom calendars, define custom date types such as workdays and holidays, and use flexible custom tags. You can use these definitions to configure conditional scheduling parameters for your tasks, which enables more flexible scheduling. You can also reference a public calendar when creating a task to avoid redundant definitions, reducing both development and long-term maintenance costs. This topic describes how to create and manage a public calendar.

Permissions

Only a super administrator or system administrator can create, modify, or delete a public calendar.

Public calendar page

Area	Description
① Public calendar list	Displays all existing public calendars. You can search for a calendar by its name or code. The following actions are available: Edit, Clone, and Delete. Edit: To edit a public calendar, you must configure its Calendar name, Code, and Calendar template. The parameters are the same as those for creating a new calendar. For more information, see Create a public calendar. Clone: To clone a public calendar, you must configure its Calendar name, Code, and Clone scope. For Clone scope, you can select Calendar + tags or Calendar only. Delete: Before deleting a public calendar, the system checks for dependencies, such as tags, calendars, or date types that reference it. If dependencies exist, you must remove them before deleting the calendar.
② Actions	Built-in function descriptions: Dataphin provides a set of built-in functions for public calendars to improve development efficiency. For a list of supported functions, see Public calendar built-in functions. Create public calendar: Creates a public calendar for use in scenarios such as offline tasks and tag conditions. For instructions, see Create a public calendar. Today: Click Today to quickly navigate to the current date in the calendar view. Page navigation: Click or to switch between calendar months. Tag search: Search for tags by entering keywords. Import: Import tags from a local file. Click Import to open the Tag import dialog box. You can click Download template to download an Excel template. Fill in the required tag information, and then upload the file (only .xlsx format is supported) to complete the import. Note Imported changes cannot be undone. We recommend cloning the calendar as a backup before importing. A single file can contain a maximum of 5,000 dates (rows). The system automatically reads data from rows 2 through 5,001. If a tag code in the Tag column of the file does not exist in the selected public calendar, the system skips that row. If a date in the Date column of the file is not in YYYY-MM-DD format, the system skips that row. If a tag has already reached its maximum limit of 36,500 assigned dates, any additional dates for that tag are skipped. Tag list and references: View the tags within the current calendar and the other items that reference it. Tags: Displays tag details, including name, code, description, and reference count. You can also view tag details, edit, clone, or delete tags from this list. Use the search bar to find a tag by its name or code. The workday tag is a built-in tag that is always displayed at the top of the list and cannot be deleted. Any reference to a date type is considered a reference to the workday tag. Referenced by: Lists objects that reference this calendar, including their project or workspace, name, type, and the reference time. From here, you can view details, edit, or delete the object. Create tag: Create a new tag for the current calendar. Tags can be used in scenarios such as offline tasks and conditional calculations. For instructions, see Create a tag.
③ Calendar	Displays the calendar grid. Each day shows its type (workday or holiday) and any associated tags. You can add a tag to a specific date or modify its date type. Add tag: When adding a tag, choose a Tag source. You can select an Existing tag or Create tag. If you choose Existing tag, you can apply any tag not already assigned to the date. If the selected tag has the current date listed as an exception, the system removes the date from the exception list and adds it to the list of specified dates. Modify date type: Changes the type of a specific date. For more information, see Modify a date type.

Create a public calendar

On the Dataphin homepage, click Plan in the top navigation bar and select Common Definitions.
On the Common Definitions page, click the Public Calendar tab. On the Public Calendar tab, click Create Public Calendar to open the Create Public Calendar dialog box.

In the Create public calendar dialog box, configure the calendar parameters.

Parameter	Description
Calendar name	The name of the calendar. The name must meet the following requirements: The name can contain Chinese characters, letters, numbers, underscores (_), and hyphens (-). The name cannot exceed 32 characters.
Code	A unique identifier for the public calendar. This value is used as a parameter when a task references the calendar. The code can contain only letters, numbers, and underscores (_) and must be 32 characters or less.
Calendar template	Initializes the calendar based on the selected template. Dataphin provides several built-in fiscal calendar templates: *4 13, 5-4-4, 4-5-4, and 4-4-5. You can also select Custom to define your own fiscal calendar. 4 * 13 fiscal calendar: Divides a 52-week year into 13 four-week months. An extra week is added to the last fiscal month every six years. 5-4-4 fiscal calendar: Divides a 52-week year into four 13-week quarters. The number of weeks in each month of a quarter follows a 5-4-4 pattern. An extra week is added to the last fiscal month every six years. 4-5-4 fiscal calendar: Divides a 52-week year into four 13-week quarters. The number of weeks in each month of a quarter follows a 4-5-4 pattern. An extra week is added to the last fiscal month every six years. 4-4-5 fiscal calendar: Divides a 52-week year into four 13-week quarters. The number of weeks in each month of a quarter follows a 4-4-5 pattern. An extra week is added to the last fiscal month every six years. Custom fiscal calendar: Allows you to define a custom start day of the week and fiscal benchmark date. Important** If you edit a calendar and change its template, all previous adjustments are lost.
Start day of the week	Specifies the first day of the week.
Fiscal benchmark date	Specifies the last day of the fiscal year.
Overflow week assignment	This setting applies to the built-in fiscal calendar templates. In these templates, an extra week is added every six years. This parameter specifies which fiscal month of the sixth year the overflow week is assigned to.
Calendar title format	The title format for each calendar month. The following formats are supported: FY{YYYY} M{n}: For example, for the 8th fiscal month of fiscal year 2024, the title is displayed as FY2024 M8. FY{YYYY} Q{n} M{n}: For example, for the 2nd fiscal month in the 3rd quarter of fiscal year 2024, the title is displayed as FY2024 Q3 M2. FY{YY} Q{n} M{n}: For example, for the 2nd fiscal month in the 3rd quarter of fiscal year 2024, the title is displayed as FY24 Q3 M2. FY{YY} M{n}: For example, for the 8th fiscal month of fiscal year 2024, the title is displayed as FY24 M8. Fiscal Year {YYYY}, Quarter {n}, Fiscal Month {n}: For example, for the 2nd fiscal month in the 3rd quarter of fiscal year 2024, the title is displayed as Fiscal Year 2024, Quarter 3, Fiscal Month 2. Fiscal Year {YYYY}, Fiscal Month {n}: For example, for the 8th fiscal month of fiscal year 2024, the title is displayed as Fiscal Year 2024, Fiscal Month 8.

Click OK to create the public calendar.

Next steps

After you create a public calendar, you can add tags to it as needed. For instructions, see Create a tag.