Currency not displaying correctly in BEX

[Former Member]

Hi,

Scenarios is : While exceuting a query on multiprovider value (currency) for one of the field is not coming correctly.

There is one query based on Multiprovider that has one key figure which give Currency for some chars.

When i checked in the Multiprovider (Right click---> Display data) and there after selecting few fields.... i am getting data

E.g for HUF (Hungary's currency) i am getting value as 356.75.

But when i check for the same value in my Bex query it is getting displayed as 35675 . I have checked Scalling as well as decimal for the same in Bex but no luck.

I have checked for some other currency (other than HUF -Hungary) and strangely its working fine. It means there is something needs to be done for Currency conversion of HUF .

I hope i am making some sense here.  Can any one help.

Thanks

[Former Member]

hello... once check the query parameters in query designer.

one option z there related to keyfigure field..