Using currency translation from query definition in Analysis for Excel

[former_member328423]

Hi All!

My problem is, that we are using a Bex Query with a defined currency translation. If we are starting the query in portal, we can activate or deactivate this currency translation (see attached picture).

This function isn´t able in Analysis for Excel, isn't it? If so, I can't find them...

If we are starting the query in Excel, we can see the EUR for all countries. It is not possible to deactivate this as an easy way to see the currency in company currency?

Any solutions for this?

Thanks and best regards,

Torsten

[former_member328423]

Hi Tammy, thanks for your answer. Is there realy no easy way to go for a function who is also included in the old BEx Analyzer? We don´t have HANA as descripted in the example and so I can´t find the screens in my system.

Best regards,

Torsten

[TammyPowlas]

Hi Torsten -it's been several years since I worked with the portal and I am very fortunate to have to only work with one currency

Could you pass the currency as a parameter in the query and then make that a filter/variable in Analysis Office at run time? See https://blogs.sap.com/2013/12/26/applying-currency-conversion-in-sap-hana-with-sap-bo-analysis-offic...