currency translations in a query

[Former Member]

in my cube i have transactions in dollars.

but in my report i want it in rupees.

where can i do currency translations in

reporting.

please give me path how to do it.

correct me if i am wrong.

conversion routines are nothing but writing

routines on currency translations

plese help me out.

i will assign full points

with regards

vishal

[Former Member]

in the report, you need only use the context sensitive menu to perform a currency translation or you can set it in the properties of the key figure in the query definition. thats the easy part, before all that works you need to have the currency table filled in with the translation factors (the easiest way is to upload it from your r/3 system, one of the choices against the source system in the source system tab - <b>"transfer exchange rates"</b>) then create a translation key (or see if one already exists)- t-code <b>RRC1</b> for 3.5 and earlier or <b>RSCUR</b> for 2004s. translation type M is standard and there are a few fields to fill out, but it is pretty easy to guess your way through it.

[former_member188975]

Hi Vishal,

Go through this thread:

Hope this helps...

[Former Member]

In Query designer Right Click on your keyfigure choose properties> you should see a section at the bottom called Currency translation> give your source currency as USD and target currency as INR ..

Converison rtoutines are not used for currency translation.

Regards

Manga(Assign points if it helps!!)