Feeder Help

Post Reply
RLReyes
Posts: 34
Joined: Thu Feb 12, 2009 7:03 pm
OLAP Product: TM1
Version: 10.1.1
Excel Version: 2010

Feeder Help

Post by RLReyes »

I have a 2 step process to record depreciation.
Step 1 ['Depreciation_','Plan'] = N: calcuates depreciation & it's fed.
Step 2 ['Depreciation Dollar','Plan'] -> the amount is pulled from step 1 & it is sent to a coa attribute(depreciation GL accounts). The amount is posted but it's not fed properly.

Any advice why my feeder statement is not correct. Thank you.

SKIPCHECK;
##Step 1##
['Depreciation_','Plan'] = N:
IF(dimix('year', !year) > dimix('year', '2014') & attrs('coa', !coa, 'DEPRECIATE') @= 'Y' & ['Dollar','Plan'] <> 0 & ['Depreciation Years','Plan','M0'] <> 0,
(['Dollar','Plan'] / ['Depreciation Years','Plan','M0'])/2,stet);

##Step 2##
['Depreciation Dollar','Plan'] = DB('CAP_INPUT',!campus,!loc,attrs('coa',!coa,'Contra_Depreciation'),!cap_line_items,!cap_type,'Plan',!year,!months,'Depreciation_');

feeders;
['Dollar','Plan'] => ['Depreciation_','Plan'];
['Depreciation_','Plan'] => ['Depreciation Dollar','Plan'];
- Rod

TM1 Version: 10.1.1
Excel: 2010
tomok
MVP
Posts: 2836
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: Feeder Help

Post by tomok »

RLReyes wrote:Any advice why my feeder statement is not correct.
Maybe because you haven't told TM1 which account the depreciation amounts are posted to in the feeder???? This is the problem with "moving" or "allocating" amounts based on an attribute. How do you feed only those accounts that should have received the allocation? This is an example of a case where you need to write a conditional feeder, where you compare the dimension element in the account dimension with the account attribute from Cap Ex cube and feed if they match and don't if there is no match.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
RLReyes
Posts: 34
Joined: Thu Feb 12, 2009 7:03 pm
OLAP Product: TM1
Version: 10.1.1
Excel Version: 2010

Re: Feeder Help

Post by RLReyes »

tomok wrote:This is an example of a case where you need to write a conditional feeder.
Thanks Tomok...I got it to work using a conditional feeder.
- Rod

TM1 Version: 10.1.1
Excel: 2010
Post Reply