SAP BPC - EPM addin sheet settings got ignored

[former_member587742]

Hi experts, we are using EPM addin 10.0 SP36 Patch1.

And we have a very strange behaviour for Sheet Options. (by definitions sheet options should be saved with workbook and remains the same for every single user.)

But, for some users, when they open the same workbook and sheet as I do, the sheet options are gone - changed.

Thank you for any ideas.

Tomas.

examples: (this is what I try to preserve within the workbook)

by SAP:

[former_member682599]

Does your report inherit the sheet options?

[former_member186338]

Theoretically it may happen if user has different EPM version then version used for file creation.

Need more investigation on your side.

[Private_Member_467521]

Hi tvarga,

Just for reference, these are the 2 manuals that I reviewed before posting the answer.

https://help.sap.com/doc/ee389f0974631014a7da368fb0e91070/10.0.35/en-US/EPMofc_10_user_en.pdf

https://help.sap.com/doc/ee389f0974631014a7da368fb0e91070/10.0.27/en-US/EPMofc_10_user_en.pdf

If you look in section 21 Sheet Options, this is what you will find:

All the best. And let us know if you could resolve the topic to share with the community.

Cheers,

Luis

[former_member186338]

Sorry again, luedazfr1

You continue to repeat the info about DEFAULT sheet options storage!

In the case of this question we have sheet options already saved in the report workbook by the person who developed this report.

And when some other user will open the report workbook the sheet options from the report workbook has to be applied. Not default sheet options!!!

So, your comment is not relevant to the question asked.

[Private_Member_467521]

Hi tvarga,

Check the user access to EPMXLClientPreference.xml in the presentation layer ( local computer / citrix) - make sure it has Write and Read at least.

The settings for the EPM Add-in are stored in the file EPMXLClientPreference.xml

I would check the users access which the functionality work correctly and compare against the one's that are in trouble.

Upon startup, the EPM Add-in reads the user preference options and tries to determine if the file exists first. If the file does not exist, the EPM Add-in will create a new EPMXLClientPreference.xml file with default values.

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

You can also edit the file manually and apply the changes. It would be another way of testing it.

Furthermore, the document link below is a great asset to help with EPM Add-in Issues

How to Debug the EPM Add-in Manual -http://docshare02.docshare.tips/files/15528/155280283.pdf

Should this help to address your topic, please kindly accept the answer.

Cheers.

Luis 🙂

[former_member186338]

Sorry, but the question was about sheet options and you are talking about user options. Answer not related to the question - downvoted.

[Private_Member_467521]

Hi vadim.kalinin,

The screenshot was wrong. The answer though is about sheet options, not user options.

Thank you

[former_member186338]

Sorry, but:

"The screenshot was wrong. The answer though is about sheet options, not user options."

From the mentioned document:

"The EPMXLClientPreference.XML file stores user preferences, current view of all connections, last selected members, and the default sheet options."

Default!!! Default settings for creating new reports!

And in the question we can see the issue with already build reports. And the mentioned settings are stored in the workbook with report.. Do you understand the difference?

[sveabecker]

Hi Vadim,

Thanks for taking the time to answer and comment. We kindly ask you to keep a professional tone while interacting with the SAP Community, e.g. exclamation marks and bold format might be understood as an aggressive tone by others.

Thank you.

Regards, Svea

[former_member186338]

svea.becker

"exclamation marks and bold format might be understood as an aggressive tone by others" Let's disable "Bold" button and restrict "!" usage. 🙂

Please look on the history of this discussion and you will understand my points. I have clearly explained that the answer is not related to the issue in the question, but the answer author insisted on the opposite.