regarding currency translation
We are trying to develope the consolidation functionality using BI Integrated planning.we are having Trail Balance data infocube (staging cube) contains data from 2 diff countries and we are copying the trail balance data to Cost center and Profit center infocubes.we create a multiprovider and generate the reports.We need to convert the 2 countries data into single currency .We are using the MTD exchange rate for currency conversion.
Please suggest me in which stage the currency shld be converted.i.e at Trail balance Cube level or after copying the data to Cost center and profit center cubes ,or in the reporting level.
Thanks in Advance
I think, you should do it while copying to PC & CC. CT has to be performed before any elimination so you do not have option of performing translation while reporting. Please share more information if this is not useful to you.