Selecting the Current Date or yesterday or previous Year, month, quarter or prevous whatever lev

Hello

Does there exist an intelligent time dimension which indicates eg the current date (, year, quarter, month, day), or the previous date (, year, month, quarter, day) ?

I could make a processing-date dimension which is based on the GetDate function of TSQL (sqlserver) ! because we daily do processing !?

Actually, we try to solve this issue in scorecard, maybe scorecard is intelligent enough to select the current or previous date in our time-dimension ?!

Kind regards

[561 byte] By [GeertG] at [2007-12-18]