currency conversion(category-rate_year/rate_period/rate_catergory)

Hi friends,

Currency translation,

rate applciation

rates are maintained with c_category(ACTUAL) .

eg: 2010.JUL|AVG|GLOBAL|INR|46.213

Main applicaiton also consists of c_category dim(FCST_JAN) and in that update rate_categoryACTUAL),rate_year(2010), rate_period(JUL), FX_SOURCE_CATEGORY(ACTUAL) and loaded local currency(LC) data into main applicatioin.

Also tried with rate_categoryACTUAL),rate_year(2011), rate_period(JUL) in c_category dim of main application. still conversion not happening.

setup script logic & business rules, but still system not performing curr conversion.

could you share any ideas to solve above problem.

thanks,

naresh