Skip to Content
0

Using currency translation from query definition in Analysis for Excel

Jul 13, 2017 at 09:51 AM

239

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Tammy Powlas
Jul 13, 2017 at 09:57 AM
0

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-office/

Share
10 |10000 characters needed characters left characters exceeded
Torsten Heck Jul 13, 2017 at 11:24 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded