Skip to Content


Hi experts.

I want to know if there´s a way to know in what language BPC is working. Is there any EPMFunction to know the language.

I need that all the reports works in English and Spanish, so what I´m looking for is a EPMFunction that tells me this. So the texts that are statical (like the name of the report) changes when the language is Spanish or English.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Apr 18, 2017 at 05:24 PM

    Language is set in the user options and you can read it using VBA GetUserOption("LanguageEdition") or GetUserOption("LanguageIsoCode") - read help SetUserOption

    Another way is to have some cell on the report with a member description you know in Spanish or English. Then just compare this cell with a known value.

    For example in the cell you have:


    And in English the result is YYYY

    In Spanish the result is ZZZZ



    Add comment
    10|10000 characters needed characters exceeded