calculate rolling 6 months to-date period

[tyody]

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

[Darek]

I think so .. Special relative n-periods .... perhaps grouped?

[snadgir30]

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.

[Darek]

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.