Page 1 of 1
Calculation is not working properly
Posted: Mon Sep 17, 2012 2:33 pm
by bsjain
Hi,
we have three elements
Elements Weight
Actual 1
PY Actual -1
Actual vs PY Actual Actual+PY Actual(Calculated)
In this PY Actul data derived from rule to take Actual data of previous year
problem:
Actual vs PY Actual value is not calculating properly, it only showing Actual value it means rule derived value is not considering in the calculation.
Kindly provide your views
Re: Calculation is not working properly
Posted: Mon Sep 17, 2012 3:17 pm
by Michel Zijlema
I moved the topic from the Enhancements subforum to the TM1 forum as this has nothing to do with enhancements - please post in the appropriate forum.
Looking at the issue this sounds like a feeder issue. Make sure the PY Actual rule is properly fed.
Michel
Re: Calculation is not working properly
Posted: Tue Sep 18, 2012 2:59 am
by bsjain
Hi,
Thanks for reply,I have used the feeder also but still its not working ,please find below
Rule
['PY_ACTUAL'] =
DB('Cube',ATTRS('xx_Year',!xx_Year, 'Prior'),'ACTUAL',!xx_Month,!xx_Cost_Center,!xx_PnL_Account);
Feeders
['ACTUAL'] => DB('cube',ATTRS('xx_Year',!xx_Year,'Prior'),'PY_ACTUAL',!xx_Month,!xx_Cost_Center,!xx_PnL_Account);
Re: Calculation is not working properly
Posted: Tue Sep 18, 2012 5:29 am
by Michel Zijlema
bsjain wrote:Hi,
Thanks for reply,I have used the feeder also but still its not working ,please find below
Rule
['PY_ACTUAL'] =
DB('Cube',ATTRS('xx_Year',!xx_Year, 'Prior'),'ACTUAL',!xx_Month,!xx_Cost_Center,!xx_PnL_Account);
Feeders
['ACTUAL'] => DB('cube',ATTRS('xx_Year',!xx_Year,'Prior'),'PY_ACTUAL',!xx_Month,!xx_Cost_Center,!xx_PnL_Account);
Hi,
Two remarks on your rule/feeder:
The Feeder is not correct: the PY_ACTUAL rule is pulling from prior year, the feeder therefore should feed in the opposite direction - so should feed next year, not prior year.
Try restricting your rule to N level by prefixing the rule with N:.
Michel