Currency Conversion

[Former Member]

Hi,

I was just given a problem for reporting with currency conversion. I dont know anything in currency conversion, i've been going through some stuff but its not quite clear as yet.

The workbook I was given outlines the problem in different sheets. I would like to share the workbook to anyone who's willing to help. Please provide email id.

I'd appreciate your help

Thanks

Fran

[former_member755961 · Accepted solution]

mustafas@intelligroup.com

[Former Member · Accepted solution]

Thanks guys for all your help,

You've solved my problem to a great extent.

Fran

Message was edited by: Fran

[Former Member]

i understand your ungency. but before posting a quesion, why cann't you just search the relavent forum for your requirement? any way below is the previous thread for currency conversion:

[Former Member]

vsn,

I have a different scenario that is why I posted a question.

Thanks for your suggestion though.

[former_member188975]

Fran,

Can you try to explain a bit about your prob here...

[Former Member]

Bhanu,

In a Cost Center report BvA report, out actuals are converting to EUR perfectly but some of the plan values are not. They should be the same. The problem is explained in much detail in my workbook. Thats why I had asked if I could just send the wb for anyone to do analysis.

I can send it to u if you want,

Thanks

[former_member188975]

You can send it to my email (from my business card on SDN)

[Former Member]

I sent u the doc.

Thanks

[Former Member]

Since I'm also trying to troubleshoot, I have a question.

I know that the cube contains Amount both in USD as well as in EUR.

In the query the EUR amount is being picked but being transferred back to USD. However, the actual amounts and October Update amounts are not the same in USD in the report, whereas they should be the same for the first 5 months of this year.

So the question is, where is the system exactly picking the rate from ? it seems to be different for actuals and october updates even though both of their values are same in the cube.

Hope i'm clear, if not let me know

Thanks

[former_member188975]

The system picks the rate from the TCURR table in BW. A simple way to see the rate is through SE38 > RCURTEST. Enter the source and target curreny, rate type and time refernce , and see how this collaborates with the values in your report.

Hope this helps...

[Former Member]

I'm not able to use se38 in Prod.

Cant view tables either.

In the selection parameters for query, there's a variable Exchange Rate Type. What impact can that have on time reference and rate?

[Former Member]

Okay, now i'll outline my requirement more clearly.

Basically, we have two RKF's (two columns) for Actuals and Plan Data. This is for Cost Centers.

We are translating USD amounts into EUR in the report.

report is drilled down on Fiscal Year Period.

If you look at first five months, the data has been Actualized, since we have actual amounts now. So amounts for actual column should be same as that in plann column (only for first 5 months). Cuz they are the same in the cube.

Problem is that they are slightly different. I guess because they are using different exchange rates. One is actual exchange rate and the other is "plan" exchange rate or the rate at the time they planned the data.

We want both to be the same only for the first 5 months of planning since that has been actualized.

How do we achieve this?

Appreciate your help.

THanks

[former_member188975]

Fran,

Are both the Actual and Plan columns being currency converted in the report? If yes, please right click each and go to the properties and see the settings made for currency conversion. Are the settings made here similar?

[Former Member]

Its "AS DEFINED IN QUERY".

I also know that they are both using different Exchange Rate Types in selection parameters.

[former_member188975]

Can you try running the queyr by giving them the same Exchange Rate Types in selection parameters...

[Former Member]

I did that already.

That way the values come out to be same, but it doesnt reflect the true amounts from planning perspective.

We still want the plan values (those not Actualized yet) to still be in the exchange rate from planning.

Hope it makes sense,

Thanks

[former_member188975]

Yes, it does. But see, if the different Exchange Rate Types are used, there is a high probability of difference in rate too. What if you convert Actuals using the rate type used for the Planning data? Would that not be correct from business view?

[Former Member]

Corrent me if I'm wrong, but we wont be able to use the actual exchange rate for planning purposes cuz we're planning in advance. We dont know what the rate will be.

What users want is to use the actual rate only with the amounts that have been "actualized".

[Former Member]

Guys,

I would really appreciate some help on this. I know it wont be too big of an issue, but since I havent worked on currency conversion, I'd like to get your input first.

I'll share the report if u give me an email id.

Thanks

Fran