Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS Transformer => Topic started by: tyody on 04 Apr 2007 10:58:18 AM

Title: calculate rolling 6 months to-date period
Post by: tyody on 04 Apr 2007 10:58:18 AM
Is it possible to calculate a rolling 6 months-to-date relative time period in transformer.  For example, today is April 4th.  Current 6 months would be October 4 2006 - April 4 2007.  Prior 6 months would be April 4 2006 - October 4 2006.   

Thanks
Title: Re: calculate rolling 6 months to-date period
Post by: Darek on 04 Apr 2007 05:54:37 PM
I think so .. Special relative n-periods .... perhaps grouped?
Title: Re: calculate rolling 6 months to-date period
Post by: snadgir30 on 31 Aug 2007 01:30:56 AM
Hi Derek/Tyody,
can you please tell me in brief how to achieve these rolling n months calculations @ transformer level?
or let me know the KB docs which i can refere to create these.
AS i have to create Rolling 24 months calculation @ Transformer Model level; i am not aware how to achive this.

Thanks in advance.
Title: Re: calculate rolling 6 months to-date period
Post by: Darek on 03 Sep 2007 11:29:40 PM
Just look up Transfromer PDFs on relative time periods. Rolling 24 months should not be difficult at all.

You need a time dimension, doesn't have to be wizard generated, and in dimension viewer start creating special categories. One of the options available is going to be relative N-Periods, or something similar. Let me know if you need S-B-S instructions.
Text only | Text with Images