Hi
I am new to TM1 and can't figure out how to dynamically lookup prior year figures. This rule works great "['Prior Year Actual']=N: ['June 2014 YTD','Actual'];", but if I want to look at anything other than FY 2015, its not so good. Is there a way to make 2014 in my code dynamic based upon to FY that is in context?
Thanks
Prior Year Actuals
-
declanr
- MVP
- Posts: 1831
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Re: Prior Year Actuals
Just put the prior year as an attribute in your period dimension and reference that in a DB formula.
Declan Rodger
-
jay10x
- Posts: 2
- Joined: Wed Oct 15, 2014 4:41 pm
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 2013
Re: Prior Year Actuals
I think I had tried everything but that. Thanks!