Skip to Content

EPMMemberProperty depends on language

Dear experts

I'm using EPMMemberProperty function with BPC 10.1 Embedded. An argument of this formula consists of a property name, but the property names depend on the language of the user. For example, if I want to retrieve the currency of an entity, I have four options, depending on the selected language for master data AND for the EPM:

EPMMemberProperty(XX;XX;"Moneda.Clave"), if my EPM is configured Spanish-Spanish.

EPMMemberProperty(XX;XX;"Moneda.Key"), if my EPM is configured Spanish-English.

EPMMemberProperty(XX;XX;"Currency.Clave"), if my EPM is configured English-Spanish.

EPMMemberProperty(XX;XX;"Currency.Key"), if my EPM is configured English-English.

It's unpredictable which languages are going to use the users in the different countries. Do I need to manage this concatenating three IF formulas? This is a step back compared to other BPC versions. Or is there any solution?

Thank you and regards


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers