TM1 Forum

hi,

I am facing a strange issue, the feeders are not being calculated unless i am hard-coding a dimension element name.Here's the detail:

Rule:
['Actual PY']=N:DB('PSP',!PSP Provider,!Domain,'Actual',ATTRS('Time',!Time,'PY'),!PSP Accounts,!Measure PSP);

--The rule is basically assigning value of element "Actual" from previous year to element "Actual PY" of dimension "scenario"
--Time dimension has attribute PY which keeps corresponding Previous year's month, to say the element "Jan 13 will have PY value Jan 12.

Feeders
I have now written a Feeder as below

['Actual'] => DB('PSP',!PSP Provider,!Domain,'Actual PY',ATTRS('Time',!Time,'PY'),!PSP Accounts,!Measure PSP); --> this does not work

but the above feeder does not populate data but when I hard code time dimension element name ( as shown below) then it shows the value.

['Actual'] => DB('PSP',!PSP Provider,!Domain,'Actual PY','Feb 13',!PSP Accounts,!Measure PSP); -- this works

Can anyone please help me find what am I doing wrong here?

Think about it, you don't want to be feeding the previous year, but rather the opposite, the previous year should be feeding the following one. You need another attribute for that, let's call it NY for 'next year' and it needs to be the reverse of what PY does. Then you use PY in your rule (like now) and NY in your feeder.

qml wrote:Think about it, you don't want to be feeding the previous year, but rather the opposite, the previous year should be feeding the following one. You need another attribute for that, let's call it NY for 'next year' and it needs to be the reverse of what PY does. Then you use PY in your rule (like now) and NY in your feeder.

hi Qml,

Thanks for your quick response, Could you please provide feeders and rule statement as you suggested above.

kind regards
Pradeep

No worry I managed to fix it.

Thanks a lot - Qml. you saved my day:)