Skip to Content
avatar image
Former Member

regarding currency translation

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Jul 15, 2009 at 11:17 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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.