Relative Time Measure Calculation in Datawarehouse ( and not in FM)

[Cognos91]

All - I am looking at implementing a relative time dimension within the datawarehouse that would enable users to drag and drop the elements to filter data set in dashboards. For example, an aging column that describes 30 day/ 45 day/ 60 day/ 90 days aging bucket that could be used as a filter. This could be extended to calculate MTD/QTD/YTD/rolling 12 months, etc.

Has anyone implemented a time dimension and if so, could you provide an example of a sample data set?

Thanks

[bdbits]

For aging like this, I would normally create a dimension with the appropriate buckets. Then at the row level during ETL, I would calculate which bucket it belongs in and link it to the proper dimension member.