Exchange rate(BI to BPC)

[Former Member]

Hi friends,

I'm trying to load exchange rates from BI to BPC.

I found some of exchange rate values are -ve value. when i click detail view it's showing /xx.

Eg. BI system: TCURR table information in one cube (TCURR contents are also same)

clinet | rate type | from curr| to curr | valid from | Exch. rate |Ratio(from)| ratio (to)

300| E |AUD | EUR| 79889168| 1.35660- | 0 | 0

If i click display button for above record, record shown in below way

client: 300

Exch rate type: E (End rate)

From curr: AUD

TO curr: EUR

valid from: 31.08.2011

exchange rate: /1.35660 (why "/" this symbol appearing here for negative values)

ratio(from): 0

ratio(to); 0

For postive exchange rate: 0.60240 (while displaying record).

Is "/", symbol means division for getting translated value.

In rate application(input currency dim, we have to maintain one property MD). Do i need consider above symbol for setting up of MD property in inputcurrency dim.

Thanks,

naresh

[former_member200327 · Accepted solution]

Hi Naresh,

If you take a look at the definition of that field you'll see than its Domain UKURS has conversion routine EXCRT. If in SE16 you uncheck "Check conversion exits" you'll see those numbers with "-" instead of "/".

It depends how you going to extract that data if you'll have "/" there or not. If you do just SELECT then conversion is not happening and you'll have negative values.

Regards,

Gersh

[Former Member · Accepted solution]

Gersh & Raju thanks for your valuable inputs.

i successfully loaded exchange rates from BI to BPC.

Naresh

[former_member190501]

Hi,

Is "/", symbol means division for getting translated value.

***Yes! you should divide....if exchange rate is -ve then it should be 1/exchange rate.

Hope it helps...

regards,

Raju