• Create a view in SQL and base your dimension off that. You might want to write this to a table to give you some flexibility to name quarters or semesters etc

    select

    Year(GetDate()) As Year_Key

    , Year(GetDate()) * 100 + Datepart(qq,GetDate()) As Quarter_Key

    , Year(GetDate()) * 100 + Datepart(mm,GetDate()) As Month_Key

    , DateName(mm,GetDate()) + ' ' + Cast(Year(GetDate()) As VarChar) As Month_Name

    Mack