CURRENY CONVERSION RULES TABLE - FORMULA FIELD

38 Views

Hi,

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?

Thanks,

Prasanth.