How to apply unique currency values in the report?

[Former Member]

Hi Guys,

I have a report showing that different currency values.I would like to have same currency values throught out the report.And one moew query i am also getting the zero's in the report so how i can supress zeros in the report?

Thanks

[Former Member]

Hi,

For unique currency, go to RSCUR, give the currency translation type and click Display.

You will enter into Edit currency conversion type screen.

Go to currency tab screen and select the source currency from data record as you are getting multiple currencies, and in target currency select appropriate option as per your requirement.

Save it and come back to query designer, go to properties of that KF, you have a conversions tab. there select the conversion type and target currency.

And regarding suppressing zeros, goto properties of the query, click on Rows/ columns tab. Under this you will find the option to supress zeros and effect on rows and columns.

Hope this will help you.

Regards,

Praveen

[Former Member]

To apply a currency conversion, go in the amounts key figure properties, and select a currency conversion key.

In BEx 3.5, in bottom of the properties window,

In BEx 7.0, it's in the conversion tab.

Ensure that a currency conversion key has been defined in your BW system (RRC3 in BW3.5, RSCUR in BI 7.0) and that currency conversion rates uploaded from R/3.