BPC epm report row limit

[former_member414993]

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.

[former_member186338]

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/

[former_member414993]

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?

[former_member186338]

"But my case needs such solution" - sorry, but it's note a clever argument!

How do you want to use this report???

Why it's not possible to export data in csv? Or export to external database? or...

[former_member414993]

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 .

[former_member186338]

Report with 177670 rows looks absolutely unusable!

Use data export to text file instead!