Skip to Content
avatar image
Former Member

BPC epm report row limit

Hello, colleagues!

I have a dimension which is consists of 177670 dimension members. I should display all this members in report (doesn't matter is there any data or not - i just need a list of all members) and here comes a trouble, because Epm just go "not-responding" if i try to refresh report. It tries to refresh ,loading is running but nothing happens. No window with error code or something like it, just endless loading animation.

Maybe I hit a limit of rows? Or is there some workaround to upload all the members in 1 report? Maybe i should change some parametres in report settings or somethig like that? May be some notes can help.

Any advice will be appreciate.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Apr 04, 2017 at 06:22 PM

    Report with 177670 rows looks absolutely unusable!

    Use data export to text file instead!

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 05, 2017 at 09:47 AM

    Vadim, I completely agreed with you. But my case needs such solution. At he present time i have this report with 155 000 rows and it works, I tried to increase the number of members in report gradually, and it works till 165 000. Any advice about how can i help system to upload so huge report?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Vadim Kalinin

      In my case this report is used to form a list of values for drop-down list in main report. It's situated on hidden worksheet and can be refreshed only manually in case of some changes dimension members has occured (very rarely). So it is like static report with possibility of manual refresh from the base. So when dimension is changed, it-supporter goes to report, manually refresh this report on hidden list and then resave whole report on the server.

      I understand, that we can export data via DM or via web portal or to external database and etc. I'm interested in the approach mentioned above because this is how the report worked till now and it minimize manual actions of IT supporter=minimize risk of mistakes. If it is not possible than our decision is to use export to .csv .

  • Apr 05, 2017 at 03:59 PM

    Drop-down list with 177670 lines is an example of bad design!

    Use VBA to get member list: GetHierarchyMembers(strConn, "", strDim)

    Then create a search form...

    Read: https://blogs.sap.com/2014/06/04/bpc-nw-10-vba-to-get-dimension-members-list-and-properties/

    Add comment
    10|10000 characters needed characters exceeded