Month Dimension

Return to Models Overview

The Month dimension holds figures in monthly granularity and allows timely aggregations of these figures. The dimension is created and maintained through the Time Editor.

Some of the settings are mandatory for the models to work correctly, as indicated in the table below. Please note that the settings for “Past”, “Future” and “Fiscal Year Start” should be set up according to the “Day” Dimension.

Settings

Valid Options

Past

At least one year earlier than the current year in which actual figures are reported.

Future

At least three years later than the current year in which actual figures are reported.

Levels

Year-Month or Year-Quarter-Month

Fiscal Year Start

Empty or January: Reports use calendar year January – December
Note that other elements may be used to indicate the fiscal year, such as February, March, etc. Reports will use the fiscal year starting in the selected month.

Additional Elements

Additional Data Element on Year Level

Mandatory

Additional Global Data Element

Mandatory

Opening Period

Mandatory

Special Periods

Optional; any selection is valid

Current Year Hierarchies

Year-To-Date

Mandatory

Year-To-Go

Mandatory

Quarter-To-Date

Optional

Quarter-To-Go

Optional

Rolling Months

Optional; any selection is valid

Full Parallel Hierarchies

This option Is not yet supported by the models – it must be turned off.

Updated August 28, 2023