Print Page - Relative Time Measure Calculation in Datawarehouse ( and not in FM)

Title: Relative Time Measure Calculation in Datawarehouse ( and not in FM)
Post by: Cognos91 on 22 Jan 2018 11:24:22 AM

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

Title: Re: Relative Time Measure Calculation in Datawarehouse ( and not in FM)
Post by: bdbits on 23 Jan 2018 05:51:28 PM

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.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Framework Manager => Topic started by: Cognos91 on 22 Jan 2018 11:24:22 AM