Skip to Content

Using currency translation from query definition in Analysis for Excel

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jul 13, 2017 at 09:57 AM

    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/

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 13, 2017 at 11:24 AM

    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

    Add comment
    10|10000 characters needed characters exceeded