Attributes in rules
Posted: Tue Sep 29, 2009 11:49 am
I have just had to change a rule that has worked up to the current month and forecast.
I can't see any difference from last month, in fact it still works going back, it's the current month that has stopped calculating.
The original rule was based on the previous month / forecast attribute.
I changed this for the DIMNM(DIMIX functions and, hey presto, it's working.
Why would it only occur on a single month, the attributes seem fine
This has worked for years, suddenly Forecast 09-09, Sep-2009 stops working.
Has anyone come across this before or should I not be using attributes in the rules at all
I can't see any difference from last month, in fact it still works going back, it's the current month that has stopped calculating.
The original rule was based on the previous month / forecast attribute.
I changed this for the DIMNM(DIMIX functions and, hey presto, it's working.
The calculated datapoint came up with the Not Fed message which was traced back to the month.#To calculate the Registered Only Invoice [Material] accrual movement
#['Material Reg Only Accrual Movement']=N:
#DB('Project Checker',!Forecast-Scenario,!Forecast-Type,!Projects,!Month,'Registered Only Invoice Accrual') -
#DB('Project Checker',attrs('Forecast-Scenario',!Forecast-Scenario,'Previous Forecast'),!Forecast-Type,
#!Projects,attrs('Month',!Month,'PriorMonth'),'Registered Only Invoice Accrual');
#simon.bradshaw 2009-09-29 attributes to calc accruals stopped working changed to DIMNM(DIMIX functions
['Material Reg Only Accrual Movement']=N:
DB('Project Checker',!Forecast-Scenario,!Forecast-Type,!Projects,!Month,'Registered Only Invoice Accrual') -
DB('Project Checker',DIMNM('Forecast-Scenario',(DIMIX('Forecast-Scenario',!Forecast-Scenario)-1)),!Forecast-Type,
!Projects,DIMNM('Month',(DIMIX('MONTH',!Month)-1)),'Registered Only Invoice Accrual');
FEEDERS
#Feeders for the Registered Only Invoice [Material] accrual
#['Registered Only Invoice Accrual']=>
#DB('Project Checker',attrs('Forecast-Scenario',!Forecast-Scenario,'Next Forecast'),!Forecast-Type,
#!Projects,attrs('Month',!Month,'NextMonth'),'Material Reg Only Accrual Movement');
#simon.bradshaw 2009-09-29 changed to DIMNM(DIMIX functions from attributes above
['Registered Only Invoice Accrual']=>
DB('Project Checker',DIMNM('Forecast-Scenario',(DIMIX('Forecast-Scenario',!Forecast-Scenario)+1)),!Forecast-Type,
!Projects,DIMNM('Month',(DIMIX('MONTH',!Month)+1)),'Material Reg Only Accrual Movement');
['Registered Only Invoice Accrual']=>
DB('Project Checker',!Forecast-Scenario,!Forecast-Type,!Projects,!Month,'Material Reg Only Accrual Movement');
Why would it only occur on a single month, the attributes seem fine
It became desperate, I wa saving the rules, re-writing the attributes, re-started the service all to no avail.Forecast-Scenario Next Forecast Previous Forecast
Forecast 07-09 Forecast 08-09 Forecast 06-09
Forecast 08-09 Forecast 09-09 Forecast 07-09
Forecast 09-09 Forecast 10-09 Forecast 08-09
Month NextMonth PriorMonth
Jul-2009 Aug-2009 Jun-2009
Aug-2009 Sept-2009 Jul-2009
Sep-2009 Oct-2009 Aug-2009
This has worked for years, suddenly Forecast 09-09, Sep-2009 stops working.
Has anyone come across this before or should I not be using attributes in the rules at all