Paulmaric,
Why can’t you use aliased Time dimension tables? Try it out; I think it should give you what you want.
Two threads on this topic are Linking Summary Tables for aggregate aware and Time condition in two contexts (shared calendar dimension).
JP Brooks (BOB member since 2002-10-22)