Setting up global setting for the EPM-Addin?

[Former Member]

I know you can make changes to the EPMXLClientPreference.XML file that change settings in the EPM-Addin.  I would like to know how this can be setup to be global settings for all users that log into BPC EMP client.  We are using Cirtix and the PDF here hints at this being possible but the direction are not clear on how to impliment it. Basically I want to be able to change the setting in the XML file and have them be global for all users logging in to the system.  We are on BPC 10 using EMP client 13 patch level 1.

[sreenivasulup]

Hi Stewart,

This is quite an old discussion. Just checking if you have managed to resolve the issue of having common client preferences and connections file for all the users logging into EPM via Citrix. We have a similar situation and want to change one particular user option for all the users.

Without a proper solution, the option has to be amended by the users every time they log into the application.

The solution is required for EPM installation on citrix.

Thanks,

Sreeni

[Former Member]

Hi Stewart,

You can get this file copied by your admin guy when the EPM add in installation is being done.

[Former Member]

I did the install where would that file be copied to?

[Former Member]

Hi Stewart,

This will be available in:

\Users\[ID]\AppData\Local\EPMOfficeClient\EPMClientPreference.xml

Hope this helps.

[Former Member]

Thanks for the reply.  Yes I see the file in the user's folder for the EPM Office Client. If you had 500 users using EPM then you would have 500 of those files. I would have to copy 500 of those files into their folders. Any new user wouln't even have an EPM folder until they first logged into Citrix and launched Excel with the EPM client installed. I know there are ways around all this using scripts but that really seems to be more complicated than it should have to be.  Does anyone know how the EPMClientPreference.xml gets created. Those default values that are in that XML file are coming from someplace, maybe that could be changed so when the file gets created and place in the user's EPM folder it would reflect the changes.

[Former Member]

Hi Stewart

The file EPMClientPreference.xml is created by the EPM Add-In when launched.

Upon startup, the EPM Add-in reads the user preference options tries to determine if the file exists first.

If the file does not exist, the EPM Add-in will create a new EPMClientPreference.xml file with default values.

The default values are built in the EPM Add-in code, primarily for situations where the EPMClientPreference.xml contains incorrect values. In such cases, the EPMClientPreference.xml will be overwritten in order to avoid launching the add-in with invalid values.

A system administrator should create batch files or scripts to provision different variants of the file as needed upon user log on. This is common standard practice - particularly in Citrix environments. The only instance when the file is reverted to the default value would be when the existing or the system admin provisioned file is incorrect.

The Installation guide mentions the file can be exported to other systems but that export facility is not managed or provided by the EPM Add-in itself, it needs to be manually created / automated using third party tools.

Stefan