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 – DecemberNote 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