Skip to Content
0

EPMDimensionPropertyValues - Missing Values

Nov 10, 2017 at 07:28 AM

44

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Vadim Kalinin Nov 10, 2017 at 07:50 AM
0

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

Show 1 Share
10 |10000 characters needed characters left 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

0