cancel
Showing results for 
Search instead for 
Did you mean: 

regarding currency translation

Former Member
0 Kudos

hi friends,

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

Ravikanth

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

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.

Best Regards,

UR

Former Member
0 Kudos

HI,

Thank you for the reply,i believe in BCS the consolidation infocube stores the converted values and also handles the elimination entries.If that is right where can I get the functionality of the BCS Info cube.

I will be happy if u can explain me the functionality.

please correct me if iam wrong ..

Regards,

Ravikanth

dan_sullivan
Active Contributor
0 Kudos

BCS uses very complicated function module for both execution and reporting and therefore you are probably better off implementing BCS, since the programs are delivered, and reading the data from BI-IP infocube using load from datastream method of BCS.

Answers (0)