1. Import and export data
  2. Export Layouts
  3. Time period labels

When you export data, the time period labels change based on which export method you use. The export methods are:

The Grid layout always uses time period labels in the same format as the module you export. However, the Tabular Single Column and Tabular Multiple Column layouts can use different labels for time periods.

Various factors affect the time period labels in exports:

  • The Model Calendar type for the model
  • The Fiscal Year Label for the model
  • Whether Line items display on columns (if you use the Tabular Multiple Column layout)

Time period label formats

In exported data, time period labels display in exports in one of two formats. This depends on the export method selected and position of the Line items dimension.

The first label format is:

Jan 20, Q1 FY20

This format applies if you select the Grid export method. It also applies to the Tabular Multiple Column export method if Line items display on rows.

The second label format is:

2020-01, FY20Q1

This format applies if you select the Tabular Single Column export method. It also applies to the Tabular Multiple Column export method if Line items display on columns (unless the dimension is nested). The month in this format always refers to the calendar month, even if you select a different start to the fiscal year.

Examples of time period labels in exports

These tables display the effects of different export configurations upon time labels for each type of Model Calendar:

Calendar Months/Quarters/Years

Type of export Position of Time dimension in module to export Week export format Month export format Quarter export format Period export format Year export format
Grid Columns N/A Jan 20 Q1 FY20 N/A FY20
Grid Rows N/A Jan 20 Q1 FY20 N/A FY20
Tabular Single Column Columns N/A 2020-01 FY20Q1 N/A FY20
Tabular Single Column Rows N/A 2020-01 FY20Q1 N/A FY20
Tabular Multiple Column Columns N/A Jan 20 Q1 FY20 N/A FY20

Tabular Multiple Column

Rows N/A 2020-1 FY20Q1 N/A FY20

Weeks: 4-4-5, 4-5-4 or 5-4-4

Type of export Position of Time dimension in module to export Week export format Month export format Quarter export format Period export format Year export format
Grid Columns Week 1 FY20 Jan 20 Q1 FY20 N/A FY20
Grid Rows Week 1 FY20 Jan 20 Q1 FY20 N/A FY20
Tabular Single Column Columns Week 1 FY20 2020-01 FY20Q1 N/A FY20
Tabular Single Column Rows Week 1 FY20 2020-01 FY20Q1 N/A FY20
Tabular Multiple Column Columns Week 1 FY20 Jan 20 Q1 FY20 N/A FY20
Tabular Multiple Column Rows Week 1 FY20 2020-01 FY20Q1 N/A FY20

Weeks: General

Type of export Position of Time dimension in module to export Week export format Month export format Quarter export format Period export format Year export format
Grid Columns W/c 1 Jan 20 N/A N/A N/A N/A
Grid Rows W/c 1 Jan 20 N/A N/A N/A N/A
Tabular Single Column Columns W/c 1 Jan 20 N/A N/A N/A N/A
Tabular Single Column Rows W/c 1 Jan 20 N/A N/A N/A N/A
Tabular Multiple Column Columns W/c 1 Jan 20 N/A N/A N/A N/A
Tabular Multiple Column Rows W/c 1 Jan 20 N/A N/A N/A N/A

Weeks: 13 4-week Periods

Type of export Position of Time dimension in module to export Week export format Month export format Quarter export format Period export format Year export format
Grid Columns Week 1 FY20 N/A Q1 FY20 P1 FY20 FY20
Grid Rows Week 1 FY20 N/A Q1 FY20 P1 FY20 FY20
Tabular Single Column Columns Week 1 FY20 N/A FY20Q1 FY20P1 FY20
Tabular Single Column Rows Week 1 FY20 N/A FY20Q1 FY20P1 FY20
Tabular Multiple Column Columns Week 1 FY20 N/A Q1 FY20 P1 FY20 FY20
Tabular Multiple Column Rows Week 1 FY20 N/A FY20Q1 FY20P1 FY20