When you export data, time period labels change based on a number of factors.

These factors include whether the export uses the grid, single column table, or multiple column table layout.

Other factors that affect time period labels in exports are the chosen Calendar Type and Fiscal Year Label in Time . Additionally, time period labels change if you export data in a multiple column table layout with line items on columns.

The tables below highlight the effect of different export layouts and model calendar types upon time labels in exported data.

Calendar Months/Quarters/Years

The table below display how time period labels export when the chosen Calendar Type is Calendar Months/Quarters/Years.

Export layoutPosition of Time dimension in module to exportWeek export formatMonth export formatQuarter export formatPeriod export formatYear export format
GridColumnsN/AJan 23Q1 FY23N/AFY23
GridRowsN/AJan 23Q1 FY23N/AFY23
Tabular Single ColumnColumnsN/A2023-01FY23Q1N/AFY23
Tabular Single ColumnRowsN/A2023-01FY23Q1N/AFY23
Tabular Multiple ColumnColumnsN/AJan 23Q1 FY23N/AFY23
Tabular Multiple ColumnRowsN/A2023-1FY23Q1N/AFY23

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

The table below display how time period labels export when the chosen Calendar Type is Weeks: 4-4-5, 4-5-4 or 5-4-4.

Export layoutPosition of Time dimension in module to exportWeek export formatMonth export formatQuarter export formatPeriod export formatYear export format
GridColumnsWeek 1 FY23Jan 23Q1 FY23N/AFY23
GridRowsWeek 1 FY23Jan 23Q1 FY23N/AFY23
Tabular Single ColumnColumnsWeek 1 FY232023-01FY23Q1N/AFY23
Tabular Single ColumnRowsWeek 1 FY232023-01FY23Q1N/AFY23
Tabular Multiple ColumnColumnsWeek 1 FY23Jan 23Q1 FY23N/AFY23
Tabular Multiple ColumnRowsWeek 1 FY232023-01FY23Q1N/AFY23

Weeks: General

The table below display how time period labels export when the chosen Calendar Type is Weeks: General.

Export layoutPosition of Time dimension in module to exportWeek export formatMonth export formatQuarter export formatPeriod export formatYear export format
GridColumnsW/c 1 Jan 23N/AN/AN/AN/A
GridRowsW/c 1 Jan 23N/AN/AN/AN/A
Tabular Single ColumnColumnsW/c 1 Jan 23N/AN/AN/AN/A
Tabular Single ColumnRowsW/c 1 Jan 23N/AN/AN/AN/A
Tabular Multiple ColumnColumnsW/c 1 Jan 23N/AN/AN/AN/A
Tabular Multiple ColumnRowsW/c 1 Jan 23N/AN/AN/AN/A

Weeks: 13 4-week Periods

The table below display how time period labels export when the chosen Calendar Type is Weeks: 13 4-week Periods.

Export layoutPosition of Time dimension in module to exportWeek export formatMonth export formatQuarter export formatPeriod export formatYear export format
GridColumnsWeek 1 FY23N/AQ1 FY23P1 FY23FY23
GridRowsWeek 1 FY23N/AQ1 FY23P1 FY23FY23
Tabular Single ColumnColumnsWeek 1 FY23N/AFY23Q1FY23P1FY23
Tabular Single ColumnRowsWeek 1 FY23N/AFY23Q1FY23P1FY23
Tabular Multiple ColumnColumnsWeek 1 FY23N/AQ1 FY23P1 FY23FY23
Tabular Multiple ColumnRowsWeek 1 FY23N/AFY23Q1FY23P1FY23

Disclaimer

We update Anapedia regularly to provide the most up-to-date instructions.