I have a list of rate types (avg,end,hist etc) defined in the Rate account dimension. The currency conversion (SPRUNConversion) procedure is running fine for all these rate types.
Now I have added two new ratetypes to the rate account dimension. I have added corresponding rate date for these accounts for all reporting currencies for the required category and time. I have then used these new rate accounts in the 'FORMULA' field of the Currency Conv Business Rule table. When I now run the SPRUNConversion procedure I get the following error
SPRunConversion Version 7.0.112
ERROR FX-310 Timeid=20090300 - Nothing Extract from Fact - RATE
When I go back to the Rate dimension and change the 'Ratetype' property for the new rates to blank (from 'FX') then I dont get any error with SPRunconversion however the accounts related to the new Ratetypes do not get processed.
I have tried everything (Full process of dimensions, Optimizing applications etc) but nothing seems to work.
Any idea why the CC table is not accepting the new rate accounts?