Hi ,
I am creating an averageCFYTD rule in my exchange rates cube dimension .
All it does is , checks the current month and say if it is august 2018 , then it takes June 2018 rate +July 2018 rate +August 2018 rate and divides by 3 and gets a rate .
I have the below rule , can anyone tell me how the feeders should look , I will be having 12 nested if statements in my rule based on month number . I am just showing 1. Below is showing for July month- takes 201812 - june rate + 201901 July rate and divides by 2
['AverageCFYTDRate']=N:if(Month(Date((DayNo(Today(1))-1),1))=7,(DB('Exchange Rates','Actual',!Currencies,'USD','Ending Rate',STR(Year(Date((DayNo(Today(1))-1),1)),4,0)|'12')+DB('Exchange Rates','Actual',!Currencies,'USD','Ending Rate',STR(Year(Date((DayNo(Today(1))-1),1))+1,4,0)|'01'))/2,0);
Any help is appreciated .
Tm1 Rule - Feeders for Current Rule
-
- MVP
- Posts: 2831
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: Tm1 Rule - Feeders for Current Rule
All a feeder does is flag a rule calculated cell as being non-empty so it doesn't matter how you derive the feeder as long as the end result is cells being fed where they should be. I would feed from Ending Rate:
Code: Select all
['Ending Rate'] => ['AverageCFYTDRate']