Skip to Content

Hi All,

Here is my first blog post .. 🙂


As SAP suggested few safety belt s-notes to avoid server(JAVA stack) crashes and improve the fastness of server.

Many end users will run the BEx reports without filter or will run entire year data, in this cases, server will go slower or will create issues(slowness) for  other end users when they try to execute reports in portal. For avoid those issues – go below

Set Bex report execution limitation in Portal:

By default Bex report execution cell  limit is 10,00,000. This has to set lower(based on client requirement. Example 650000 cells

Check default settings in below table.

Se16>> table “ RSADMIN “ execute.  (If don’t have any setting’s for

BICS_DA_RESULT_SET_LIMIT_DEF or BICS_DA_RESULT_SET_LIMIT_MAX  please set )

Diff b/w DEF and MAX:   DEF – when the user ran the report,  limitation is DEF number. If the user wants to extend the cell limit, end users can increase MAX limit by clicking SETTINGS option.

Set values:  se38 >> programe SAP_RSADMIN_MAINTAIN >> execute (F8) then provide the parameters

BICS_DA_RESULT_SET_LIMIT_DEF = 500000 cells

BICS_DA_RESULT_SET_LIMIT_MAX  = 650000 cells then OK. We can modify also my clicking modify if wants to change the cell limit.

Portal execution limit msg.jpg

entend limit in web.jpg

For more details see s-note: 1127156

Set BEx report download to Excel/PDF limitation in Portal:


These limitations enhance the above settings.

The memory consumption may be larger for the export to Excel or to PDF than for the execution in the Web; therefore, a lower value can be specified as the safety belt for Excel and PDF.

BICS_DA_RESULT_SET_LIMIT_XLS =300000

BICS_DA_RESULT_SET_LIMIT_PDF = 300000

Execution default limit is 500000 and Max limit is 650000 in portal but download to excel/pdf is 300000 cells only if we set XLS and PDF setting in RSADMIN table.

Message when Excel limit cross.

/wp-content/uploads/2015/02/excel_635949.jpg

After Open Excel:

excel mesg.jpg

Message when PDF limit cross.


/wp-content/uploads/2015/02/pdf_635951.jpg



pdf msg.jpg


For more details see s-note: 1622134

Set report execution limitation in BEx Analyzer:


We know BEx reports can execute in Web and Analyzer.

We discussed web Safety belt setting in above. Below Analyzer settings.

ANALYZER_LIMIT_DEF: The default number of maximum cells if no further setting is specified. The default number can be overwritten locally in BEx Analyzer for each data provider.

ANALYZER_LIMIT_MAX: the absolute maximum number of cells (see below). The maximum number cannot be overwritten in BEx Analyzer.


ANALYZER_LIMIT_DEF=500000

ANALYZER_LIMIT_MAX = 750000


Message when cross limit:

Analyzer msg.jpg

For more details see s-note: 0001411545


How to select Max limit in Analyzer


After executing the report in Analyzer click the workbook settings as shown below for increasing the MAX limit. Increasing MAX limit is report specific.

Analyzer prop.jpg

Data Provider >> Properties

/wp-content/uploads/2015/02/propertes_635955.jpg


cell limit inc.jpg


Thanks

Nageswara Polaka


To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

Leave a Reply