TM1 Forum

Posted: **Thu Jan 03, 2013 10:25 am**

Guys,

Bit of help with feeders if possible....

I'm using a rule which roles forward rates each month (in a split time dimension). It puts last month's rate in this month unless something else is entered this month.
It uses an input and output nominal, rolled up into a reported nominal, with Input weighted at zero.

See below for example code....

Code: Select all

###
['Expected Return On Capital Output']=	N:IF(
						DB('Reporting_Scheme',!Version,!Accident Year,!Underwriting Year,!LineOfBusiness,!Company,!Cover Type,!Product,!Scheme,'Expected Return On Capital Input',!Month,!Year)<>0,
						DB('Reporting_Scheme',!Version,!Accident Year,!Underwriting Year,!LineOfBusiness,!Company,!Cover Type,!Product,!Scheme,'Expected Return On Capital Input',!Month,!Year)
					,
						DB('Reporting_Scheme',!Version,!Accident Year,!Underwriting Year,!LineOfBusiness,!Company,!Cover Type,!Product,!Scheme,'Expected Return On Capital Output',ATTRS('Month',!Month,'Prior Month'),!Year) 
					);
###

My Feeder currently is...

Code: Select all

['AA_Adj']=>	DB('Reporting_Scheme',!Version,!Accident Year,!Underwriting Year,!LineOfBusiness,!Company,!Cover Type,!Product,!Scheme,!Nominal,ATTRS('Month',!Month,'Next Month'));

Whereby 'AA_Adj' is the 'Version' where the rates are input.

I'm getting a fed value in the cube for the direct month in the reported nominal, so I assume this feeder is half working, but half is no good!

Any help would be great,

Cheers

Posted: **Thu Jan 03, 2013 10:50 am**

A couple of things that spring to mind:

* The left-hand side of the rule is saying calculate 'Expected Return On Capital Output' but you are feeding from 'AA_Adj' (as a version). Basically you are feeding from a different slice than you are calculating which is going to be confusing. Also, do you really need this version when the 'input nominal' is handling that for you?

* I would have expected the right hand side of the rule to be looking at the AA_Adj version if that's where you expect the input to be. And, for the feeder to use that cube area:

Code: Select all

['AA_Adj',  'Expected Return On Capital Output'] =>...

* Your feeder omits the !Year (last argument in the DB()) from the target.

* You should make sure that your attributes are correctly set-up as well for 'Prior Month' and 'Next Month' - do they definitely contain the correct values?

HTH

TM1 Forum

Feeder assistance

Feeder assistance

Re: Feeder assistance