Month_YTD Dimension (Financial Consolidation)
Return to Financial Consolidation Model Overview.
The Month_YTD
dimension holds figures in monthly granularity. All figures are stored as Year-To-Date figures which is the range of beginning of the fiscal year until the end of each month. 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-Month_YTD or Year-Quarter-Month-Month_YTD |
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 |
Must be turned off |
Special Periods |
Optional; any selection is valid |
Current Year Hierarchies |
|
Year-To-Date |
Not valid for a time dimension with YTD level. |
Year-To-Go |
Not valid for a time dimension with YTD level. |
Quarter-To-Date |
Not valid for a time dimension with YTD level. |
Quarter-To-Go |
Not valid for a time dimension with YTD level. |
Rolling Months |
Must be turned off |
Full Parallel Hierarchies |
This option Is not yet supported by the models – it must be turned off. |
Updated August 28, 2023