• Just a brief note.

    This would be ok until you look at the "special" cases we find everyday with clients such as :

    - wanting weekday/nonworking day (including national holidays) per country,

    - end of month days being decided by the company not actual calendar,

    - requiring more than 100 days (maxrecursion option accepted),

    - being able to change the information for a day easily using values not code,

    On the maintainance side not really a problem if you design the cube with 2 dimension tables (date and time). In one table all dates, in the other all times.

    Fitz