Tuesday, May 10, 2011

Few more BEx messages 3

Here series of pots related to BEx messages continues. Some month ago I wrote a post about maximum lines that BEx report can display. Here are warning messages related to this topic:

Result set too large (1019760 cells); data retrieval restricted by configuration (maximum = 500000 cells)
Maximum number of rows (65535) exceeded. Result is incomplete. BRAIN 67565535

Anyway conclusion is the same: You cannot get more then 65536 from Excel. For detail see How long BEx report in Excel can be?

More post on that topic:


Francis said...

If you run the report using the portal, you can increase the default value of 500000 rows, manually.
If the portal is locked and the value cannot be changed, run the tcode SAP_RSADMIN_MAINTAIN, enter the object BICS_DA_RESULT_SET_LIMIT_MAX and set the desired value.

Anonymous said...

Hi! Can you please advice on the maximum amount of entries I can copy and paste into a field for BI7 report? For example, can I copy and paste 500 account numbers (separated by “;” of course) into a field?

sapper said...

Hi Anonymous, into which environment BEx's Excel or in web is your question related to? sapper