################################################ # Date Dimension # ################################################ Default Hierarchy: Calendar Levels: Root Level -> Year -> Quarter -> Month Members: Root +--2019 | +--Q1 | | +--M1 | | +--M2 | | +--M3 | +--Q2 | | +--M4 | | +--M5 | | +--M6 | +--Q3 | | +--M7 | | +--M8 | | +--M9 | +--Q4 | +--M10 | +--M11 | +--M12 +--2020 | +--Q1 | | +--M1 | | +--M2 | | +--M3 | +--Q2 | | +--M4 | | +--M5 | | +--M6 | +--Q3 | | +--M7 | | +--M8 | | +--M9 | +--Q4 | +--M10 | +--M11 | +--M12 +--2021 | +--Q1 | | +--M1 | | +--M2 | | +--M3 | +--Q2 | | +--M4 | | +--M5 | | +--M6 | +--Q3 | | +--M7 | | +--M8 | | +--M9 | +--Q4 | +--M10 | +--M11 | +--M12 +--2022 +--Q1 | +--M1 | +--M2 | +--M3 +--Q2 | +--M4 | +--M5 | +--M6 +--Q3 | +--M7 | +--M8 | +--M9 +--Q4 +--M10 +--M11 +--M12 Hierarchy: Financial Levels: Root Level -> Financial Year -> Financial Quarter -> Financial Month Members: Root +--Financial 2019 | +--Q1 equivalent to [Date].[Calendar].[2019].[Q2] | | +--M1 equivalent to [Date].[Calendar].[2019].[Q2].[M4] | | +--M2 equivalent to [Date].[Calendar].[2019].[Q2].[M5] | | +--M3 equivalent to [Date].[Calendar].[2019].[Q2].[M6] | +--Q2 equivalent to [Date].[Calendar].[2019].[Q3] | | +--M4 equivalent to [Date].[Calendar].[2019].[Q3].[M7] | | +--M5 equivalent to [Date].[Calendar].[2019].[Q3].[M8] | | +--M6 equivalent to [Date].[Calendar].[2019].[Q3].[M9] | +--Q3 equivalent to [Date].[Calendar].[2019].[Q4] | | +--M7 equivalent to [Date].[Calendar].[2019].[Q4].[M10] | | +--M8 equivalent to [Date].[Calendar].[2019].[Q4].[M11] | | +--M9 equivalent to [Date].[Calendar].[2019].[Q4].[M12] | +--Q4 equivalent to [Date].[Calendar].[2020].[Q1] | +--M10 equivalent to [Date].[Calendar].[2020].[Q1].[M1] | +--M11 equivalent to [Date].[Calendar].[2020].[Q1].[M2] | +--M12 equivalent to [Date].[Calendar].[2020].[Q1].[M3] +--Financial 2020 | +--Q1 equivalent to [Date].[Calendar].[2020].[Q2] | | +--M1 equivalent to [Date].[Calendar].[2020].[Q2].[M4] | | +--M2 equivalent to [Date].[Calendar].[2020].[Q2].[M5] | | +--M3 equivalent to [Date].[Calendar].[2020].[Q2].[M6] | +--Q2 equivalent to [Date].[Calendar].[2020].[Q3] | | +--M4 equivalent to [Date].[Calendar].[2020].[Q3].[M7] | | +--M5 equivalent to [Date].[Calendar].[2020].[Q3].[M8] | | +--M6 equivalent to [Date].[Calendar].[2020].[Q3].[M9] | +--Q3 equivalent to [Date].[Calendar].[2020].[Q4] | | +--M7 equivalent to [Date].[Calendar].[2020].[Q4].[M10] | | +--M8 equivalent to [Date].[Calendar].[2020].[Q4].[M11] | | +--M9 equivalent to [Date].[Calendar].[2020].[Q4].[M12] | +--Q4 equivalent to [Date].[Calendar].[2021].[Q1] | +--M10 equivalent to [Date].[Calendar].[2021].[Q1].[M1] | +--M11 equivalent to [Date].[Calendar].[2021].[Q1].[M2] | +--M12 equivalent to [Date].[Calendar].[2021].[Q1].[M3] +--Financial 2021 | +--Q1 equivalent to [Date].[Calendar].[2021].[Q2] | | +--M1 equivalent to [Date].[Calendar].[2021].[Q2].[M4] | | +--M2 equivalent to [Date].[Calendar].[2021].[Q2].[M5] | | +--M3 equivalent to [Date].[Calendar].[2021].[Q2].[M6] | +--Q2 equivalent to [Date].[Calendar].[2021].[Q3] | | +--M4 equivalent to [Date].[Calendar].[2021].[Q3].[M7] | | +--M5 equivalent to [Date].[Calendar].[2021].[Q3].[M8] | | +--M6 equivalent to [Date].[Calendar].[2021].[Q3].[M9] | +--Q3 equivalent to [Date].[Calendar].[2021].[Q4] | | +--M7 equivalent to [Date].[Calendar].[2021].[Q4].[M10] | | +--M8 equivalent to [Date].[Calendar].[2021].[Q4].[M11] | | +--M9 equivalent to [Date].[Calendar].[2021].[Q4].[M12] | +--Q4 equivalent to [Date].[Calendar].[2022].[Q1] | +--M10 equivalent to [Date].[Calendar].[2022].[Q1].[M1] | +--M11 equivalent to [Date].[Calendar].[2022].[Q1].[M2] | +--M12 equivalent to [Date].[Calendar].[2022].[Q1].[M3] +--Financial 2022 +--Q1 equivalent to [Date].[Calendar].[2022].[Q2] | +--M1 equivalent to [Date].[Calendar].[2022].[Q2].[M4] | +--M2 equivalent to [Date].[Calendar].[2022].[Q2].[M5] | +--M3 equivalent to [Date].[Calendar].[2022].[Q2].[M6] +--Q2 equivalent to [Date].[Calendar].[2022].[Q3] | +--M4 equivalent to [Date].[Calendar].[2022].[Q3].[M7] | +--M5 equivalent to [Date].[Calendar].[2022].[Q3].[M8] | +--M6 equivalent to [Date].[Calendar].[2022].[Q3].[M9] +--Q3 equivalent to [Date].[Calendar].[2022].[Q4] +--M7 equivalent to [Date].[Calendar].[2022].[Q4].[M10] +--M8 equivalent to [Date].[Calendar].[2022].[Q4].[M11] +--M9 equivalent to [Date].[Calendar].[2022].[Q4].[M12]