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'];
Feeder Help
-
- Posts: 34
- Joined: Thu Feb 12, 2009 7:03 pm
- OLAP Product: TM1
- Version: 10.1.1
- Excel Version: 2010
Feeder Help
- Rod
TM1 Version: 10.1.1
Excel: 2010
TM1 Version: 10.1.1
Excel: 2010
-
- 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
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.RLReyes wrote:Any advice why my feeder statement is not correct.
-
- Posts: 34
- Joined: Thu Feb 12, 2009 7:03 pm
- OLAP Product: TM1
- Version: 10.1.1
- Excel Version: 2010
Re: Feeder Help
Thanks Tomok...I got it to work using a conditional feeder.tomok wrote:This is an example of a case where you need to write a conditional feeder.
- Rod
TM1 Version: 10.1.1
Excel: 2010
TM1 Version: 10.1.1
Excel: 2010