Skip to Content
0
Dec 14, 2006 at 10:49 AM

Currency Translation

39 Views

Hi all,

Can you please share your thoughts on the following?

Question

-


1)Convert Document Currency to Local currency(company code currency)

eg: USD to EUR

2)Then again convert Local currency to Global reporting currency

eg: EUR to GBP

Solution

-


1)We "converted Document Currency to Local currency" in BEx.

2)Again when we convert the Local currency to Global reporting currency it does not give correct values(does not work as required).

1)We have a KF1 with document currency in ODS1.

2)We have a KF2 and converted "Document Currency to Local currency".

3)Created a calculated key figure CKF1 based on KF1.

4)In the CKF1 properties we set the currency translation to convert to Local Currency.

5)Again created a formula F1 using CKF.

6)In the F1 properties we set the currency translation to convert to GBP.

7)In the KF2 properties we set the currency translation to convert to GBP.

8)We thought F1 and KF2 should match.But not.

We implemented step 1 "Convert Document Currency to Local currency" in datastaging for one of the Business area.We could not implement the same due to time constraints and too much IST and UAT involved.

We assume that converting twice in query is not working.

Any thoughts please?

Thanks

TK