Skip to Content

     When reporting with BOBJ Clients on BW data users might request too detailed information pushing BW system over its limit and causing performance / system stability issues. There is a safety belt functionality which allows to set a maximum number of cells retrieved from BW. In my blog I will explain to set safety belt for different BOBJ Clients. If you do not authorization or system to play with you can create trial BW / BOBJ landscape in Cloud like exaplined here

     Setting BW Safety Belt for Analysis OLAP

     It is set in Central Management Console updating Properties of Adaptive Processing Server

   BW Safety Belt 1.jpg

Here are setting and default values

Setting Default Value

Maximum Client Sessions

15
Maximum number of cells returned by a query 100,000
Maximum number of members returned when filtering 100,000

To demonstrate how Safety Belt is working lets change Maximum number of cells returned by a query to something small, for example, 5.

BW Safety Belt 2.jpg

and restart the Server

BW Safety Belt 3.jpg

Now if we run Analysis for OLAP without drill down, then no error occurs

BW Safety Belt 4.jpg

But if we drill down by Product or Sold-to number of cells will exceed the limit.

BW Safety Belt 5.jpg

     Setting BW Safety Belt for Web Intelligence and Crystall Report

     It is set maintaining BICS_DA_RESULT_SET_LIMIT_DEF and BICS_DA_RESULT_SET_LIMIT_MAX paremeters in RSADMIN table. To demonstrate how safety belt works lets set the limits to some small value, for example, 5 running SAP_RSADMIN_MAINTAIN program.

BW Safety Belt 6.jpg

BW Safety Belt 7.jpg

Now if we run Web Intelligence report without drill down, then no error occurs

BW Safety Belt 8.jpg

But if we drill down by Product or Sold-to number of cells will exceed the limit.

BW Safety Belt 9.jpg

Safety Belt for Crystal Reports works the same way as for Web Intelligence

To report this post you need to login first.

Be the first to leave a comment

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

Leave a Reply