Skip to Content

What is the limit for rows returned by a Bex query Design Studio with BW on HANA?

May 08, 2017 at 04:35 PM


avatar image

Hello DS pros,

Just wondering if there is maximum limit to the number of rows that can be returned to Design Studio with a Bex query?

I'm running DS 1.6 sp4 with a BW on HANA backend.


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
avatar image
Former Member May 08, 2017 at 08:56 PM

Bex queryAccess in Design Studio:

@ Prompts Level –

Maximum number of members your number , default: 100 Specifies the maximum number of members displayed in the value help for prompts.

If the number of members is greater than the value for this property, no values are displayed. Instead, the application user has to limit the number by searching for the text or key of one or more values.

@ Data Display level - Safety belt is used to restrict large result-set of data retrieval from SAP BW using BICS connections.

Universe Access in Design Studio:

  • Maximum Result Set
  • The result set has a fixed limit of 20000 rows or 200000 data cells. If either limit is exceeded, no data is displayed

    Show 1 Share
    10 |10000 characters needed characters left characters exceeded

    Thanks a million Sreenivasulu,

    Your answer was informative beyond my wildest dreams!