on 07-15-2009 5:08 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
15 | |
4 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.