• Thank you Alvin, your remark together with the link from wildt about

    Populating a Kimball Date Dimension

    are what I am looking for.