Skip to Content
avatar image
Former Member

EPMDimensionPropertyValues - Missing Values

Hi All,

We are missing few values while using the EPM function : EPMDimensionPropertyValues

We are using SAP BPC 10, below are the components details

SAP_BW 730 SP14

CPMBPC 800 SP19

EPM Addin 10 SP 25 Patch 1 .Net3.5 Build 9489

Note : There is a thread opened in 2013 for the same topic, Where dissusion went on saying in EPM Addin after SP15 might resolve the issue of more than 255 characters to be displayed. But still in SP25 i am facing the issue. Please help me..

Thank you.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Nov 10, 2017 at 07:50 AM

    First - primary tag has to be EPM Add-In for Excel Please correct!

    If you use dropdown list then the limit 255 is Excel limit - nothing to do with EPM SP. Use cell range.

    Like:

    =EPMDimensionPropertyValues(;"COST_CENTER","BPC_COMPANY_CODE",B3,I:I)

    I:I - column containing full list

    B3 will have data validation: list =$I:$I

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Vadim,

      Changed the primary tag to EPM Add-In for Excel.

      Cell Range is working.

      Thank you for your valuable input. :)

      Regards,

      Gowtham MN