HOW TO KNOW BPC LANGUAGE

[mayiya]

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.

[former_member186338 · Accepted solution]

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")

[mayiya · Accepted solution]

Thanks Vadim.

I´m trying by VBA using the API GetUserOption. I need that the result would be written in some cell, for example cell G3.

So, If the LanguageEdition is in English on this cell G3 the value would be "en".

I tried with LanguageEdition and LanguageIsoCode but there´s not value, the cell is empty.

Function AFTER_WORKBOOK_OPEN()

Dim epm As New EPMAddInAutomation

Dim str As String

str = epm.GetUserOption(LanguageEdition)

Hoja1.Range("G3").Value = str

End Function

[former_member186338 · Accepted solution]

Instead of

str = epm.GetUserOption(LanguageEdition)

write

str = epm.GetUserOption("LanguageEdition")

function parameter is a string!

P.S. To prevent errors like the above use:

Option Explicit

before your code 🙂

[mayiya · Accepted solution]

Thanks for your help. Is exactly what I needed. It works fine.

[former_member186338 · Accepted solution]

But why you don't like my second proposal - absolutely easy and require no VBA?