Day Dimension
Return to Models Overview
Day
dimension holds figures in daily 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 “Month” Dimension.
Settings |
Valid Options |
Past |
At least one year earlier than the current year for which actual figures are reported, and at least as far in the past as the setting in |
Future |
At least three years later than the current year for which actual figures are reported, and at least as far in the future as the setting in |
Levels |
Year-Month-Day or Year-Quarter-Month-Day |
Fiscal Year Start |
Empty or January : Reports use calendar year January – DecemberOther elements could be used are February , March , etc.: Reports use fiscal year starting in the selected month |
Additional Elements |
|
Additional Data Element on Year Level |
Mandatory |
Additional Data Element on Month Level |
Optional |
Opening Period |
Optional |
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 |
Month-To-Date |
Optional |
Month-To-Go |
Optional |
Rolling Months |
Optional; any selection is valid |
Weeks |
|
Week Hierarchy |
Optional |
First day of the week |
Optional; any selection is valid |
Minimum of days in a week |
Optional; any selection is valid |
Updated August 28, 2023