Skip to Content
avatar image
Former Member

Defaulting display of ID/Description in Excel EPM Add In

Looking for method to have preference of displaying ID/Description in member selector persist after exiting Excel.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    May 19, 2017 at 05:37 AM

    Not the most effective way to do it but on EPM Context Pane, if you select the desired display method for a given dimension, it persists even after exiting excel. So, if you want to set it for say ID only for all dimensions, then for every dimension on context pane, choose ID only once and it will stay.

    Obviously, if there are multiple environments/models in question, this method fails miserably. But I don't believe there is any defined EPM option to set it all across (not sure though).

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks, after trying this I found that it results in this entry on the EPMXLClientPreference.xml file:

      <DisplayProperty>1565febf-56d4-42f9-85ee-0ae24db747b3</DisplayProperty>

      That setting is the one Vadim indirectly mentioned below in his linked response (but that linked response doesn't make it clear that this is what the setting above controls).

  • May 19, 2017 at 05:41 AM

    Why not to search?

    Please read my answer here:

    https://archive.sap.com/discussions/thread/3881480

    Add comment
    10|10000 characters needed characters exceeded

    • No idea what do you mean by "I had to click the "read full thread" button"...

      You can open this xml file using VBA and replace one string to another. This is the only way to manage this setting using some code. You can set defaults on this workbook open event (or better in EPM AFTER_WORKBOOK_OPEN event function).