Skip to Content
0

EPMMemberProperty depends on language

Nov 25, 2016 at 10:19 AM

43

avatar image

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

Sergio

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers