Skip to Content

BICS - BW Safety Belt feature

Hi all, I'm currently facing an issue with using BICS and WebI. The reporting data isn't very well aggregated, so a large result set will be returned. ...in my case it's > 500.000 rows... I found a SAP Note 1750332 and 112756 which described an adjustment of this BW Safety Belt feature for BICS. Does anyone has some experience with customizing this parameter ? SAP Note 1750332 Symptom Error 'Result set too large (xx cells); data retrieval restricted by configuration (maximum = 5 cells) (WIS 00000)' in WebIntelligence BI 4 SP04 Resolution Change the value for object BICS_DA_RESULT_SET_LIMIT_MAX in BW: 1. check current value: SE16, table name “RSADMIN”, execute current value for object BICS_DA_RESULT_SET_LIMIT_MAX is set to 5 2. change the value: SE38, Enter “SAP_RSADMIN_MAINTAIN” in the program name field and click on the Execute Button, increase value, update, execute IMPORTANT NOTE: This value defines the Safety Belt feature as described in SAP Note 1127156. From BW perspective, the Safety Belt needs to be correctly set according to the system sizing, and no mass data requests should be processed at all that could exceed this limit. Increasing the value might have negative impact on the system performance and, if too high, cause out of memory dumps. So it needs to be used cautiously and in sync with available system resources. If using BW Java with the same ABAP backend, this parameter will also impact this frontend. cheers, Sascha
BICS.jpg (16.8 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jan 03, 2014 at 11:43 AM

    I think you need to make a modification in AdaptiveProcessingServer as well as per the link: http://scn.sap.com/thread/3346952

    I know i'm replying to an old post, but its better to keep it updated towards the solution.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.