Bex Multiple Exchange Rates

[Former Member]

Hi:

Does anybody know if it's possible to translate a key figure into two currencies? First from document currency to local currency and then from local currency to group currency? I tried by creating two currency conv. types; one for local currency using "EURX" rate and the other for group currency using "M" rate. Have two key figure columns one selecting the local currency and the other group currency. The local currency looks good. But the group currency is not taking the results from the first conversion and converting to group currency. It's just taking the document currency value and converting it to group currency. I also tried using a restricted key figure but I get the same results.

Does anybody know how to do this?

Please let me know.

Thanks a lot!

Helena

[Former Member]

Helena,

Don't think that this is possible at run time. It can be done in the update rules through a routine.

Cheers

Aneesh

[Former Member]

Aneesh:

That's what I thought and you confirmed it. I'm going to put it in the start up routine when loading the data to the cube. I already have other code in there.

Thanks again!

Regards,

Helena