on 12-13-2017 10:32 AM
Hi all,
I am using member names in an EPM report to overwrite the standard element description. Is it possible to make these multilingual by using formulas or cell-references instead of simply typing text?
So instead of having a fixed text of "Not Dummy" I am looking to make it dependant on the user's language settings.
Thanks,
Arnold
You can do something like you want using local member and vba to get language code:
Create a user function:
Option Explicit
Dim epm As New FPMXLClient.EPMAddInAutomation
Public Function GetLang()
GetLang = epm.GetUserOption("LanguageIsoCode")
End Function
In Excel cell you can use it like:
=IF(GetLang()="en";"English";"Other")
and you can create a local member with this function.
P.S. Application Language can be found using:
Public Function GetApLang()
GetApLang = epm.GetUserOption("LanguageEdition")
End Function
use it the same way.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Wouldn't be easier then to maintain the descriptions in an unused language by your company and then use VBA to set the to change the User language? This is obviously counting that the inversed VBA provided by Vadim below would work... but it would save you time having to maintaining the overrides if you have multiple reports - or if one of the descriptions change..
epm.SetUserOption("LanguageIsoCode","RU") or
epm.SetUserOption("LanguageEdition","RU")
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vadim,
I know but I have this one report where I do not want to see the normal description (which we have in multiple languages in the system) but a different one. So I am using the member names function in the EPM Add-In to overwrite the standard description.
It is this name that I would like to show language dependant as well.
So let's say I have a flow element which has a description of "closing balance". This description is stored in English and German in the system, so on most reports I have no issue.
However, I do have one report where I want a description of "my amount" instead of "closing balance". This is where I use the member names function and it works as long as all my users use English as their language. When a user uses a different language, they still see "my amount" instead of the German translation.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Arnold,
You can load member descriptions in multiple languages. Then the user will see description based on his language settings.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.