rule issues after 10.2.2 upgrade
Posted: Tue Nov 04, 2014 8:42 pm
Code: Select all
#Forecast definitions for historical months
[{'FCST I Draft1','FCST I Draft2','FCST I Draft3','FCST I Final','FCST II Draft1','FCST II Draft2','FCST II Draft3','FCST II Final'}] = N:
IF(DB('zForecastTime', !Versions, 'COGS', !Time, 'NumValue') = 1 , ['Actual'], CONTINUE);
['USD' , 'Transactional Forex to USD'] = N: 1;
#AVG calcs
['TR_USD_Hold'] = N: ['Transactional Forex to USD'];
['TR_USD_Count'] = N: IF(['Transactional Forex to USD'] <> 0 , 1 , 0);
['Transactional Forex to USD'] = C: ['TR_USD_Hold'] \ ['TR_USD_Count'];
We have a simple FOREX cube (Versions, currencies, time, measures), rules as above. We found the following issue when upgrading from 10.1.1 to 10.2.2
The rule above results in not being able to manually enter to future months of the FCST versions (to 'Transactional Forex to USD'), although you would expect no rule applies for them. Actually, we lost all data in these future months. In cube viewer, these months appear with white, when I right click there is no Trace Calculation option but when I try to key in data it says "Data Spread failed" (which is obviously not a data spread issue because I am on leaf level)
If I replace the last line before the N: level conditional rule, it works fine
The code above worked fine with 10.1.1
I have AllowSeparate...=T, and I tested with MTQ=2 and =1
I would definitely think this is a bug and it is a very dangerous one as it could result in massive data loss
I would be interested in your opinion about this usse
Thanks
Matyas