Skip to Content

HOW TO KNOW BPC LANGUAGE

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 42.4.3.3 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:

    =EPMMemberDesc("[COST_CENTER].[PARETH1].[CC_XXXX]")

    And in English the result is YYYY

    In Spanish the result is ZZZZ

    then:

    =IF(EPMMemberDesc("[COST_CENTER].[PARETH1].[CC_XXXX]")="ZZZZ","Spanish","English")

    Add comment
    10|10000 characters needed characters exceeded